Solved

Find and Replace

Posted on 2011-03-16
4
277 Views
Last Modified: 2012-05-11
Good Afternoon

I am looking to do a find and replace on the following sum:

=(SUMPRODUCT((Centre=C$4)*(TEXT(Date,"mmmm yyyy")="JANUARY 2011")*(Group=$A5)*(Value>0)*(Value)))

Replace *(Value)
For ,Value)

When I do the find and repalce I am left with ,Value) as the value in the cells?

Many thanks
0
Comment
Question by:Washcare
  • 2
4 Comments
 
LVL 1

Expert Comment

by:kiran_ramisetti
ID: 35148511
select Exact word option do the replace operaton
0
 

Author Comment

by:Washcare
ID: 35148567
I do not seem to have that option?
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 35148607
If you want to replace an actaul * you need to precede with a tilde symbol ~ so that Excel knows you are not using * as a wildcard, so use this in "Find what"

~*(Value)

regards, barry
0
 

Author Closing Comment

by:Washcare
ID: 35148758
Many thanks
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now