How to replace * with / in all formulas in an excel sheet

Solved/Closed
Report
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
-
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
-
hi Guys,

does anyone of you know please how to replace the multiply sign with a divide sign in all of the formulas in an excel sheet? I could not figure it out on my own unfortunately.

thank you so much

2 replies

Try this:

Ctrl H - Find and Replace
Then in the 1st field 'Find What:' put ~* and in the 2nd field 'Replace with:' put /

Using the tilde '~' as the 1st character in the field tells it that you are searching for the '*' rather than using it as a wildcard.
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018

Thanks a lot, Ray. However after putting ~* in the Find field Excel does not recognize it unfortunately. :(
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Is the dialog box rejecting it or is it simply not finding it in the sheet?

BEFORE:


AFTER:
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018

Ray, thanks, it works now! Must have done something wrong the first time. Thanks a lot for your help, really really appreciate it!