Link to home
Start Free TrialLog in
Avatar of Washcare
WashcareFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Find and Replace

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
Avatar of kiran_ramisetti
kiran_ramisetti

select Exact word option do the replace operaton
Avatar of Washcare

ASKER

I do not seem to have that option?
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Many thanks