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

Solved/Closed
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Feb 16, 2015 at 06:54 AM
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Feb 18, 2015 at 02:17 AM
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.
0
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018
Feb 17, 2015 at 04:25 AM
Thanks a lot, Ray. However after putting ~* in the Find field Excel does not recognize it unfortunately. :(
0
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 25
Feb 17, 2015 at 01:58 PM
Is the dialog box rejecting it or is it simply not finding it in the sheet?

BEFORE:


AFTER:
0
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018
Feb 18, 2015 at 02:17 AM
Ray, thanks, it works now! Must have done something wrong the first time. Thanks a lot for your help, really really appreciate it!
0