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
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Feb 18, 2015 at 02:17 AM
Related:
- How to replace * with / in all formulas in an excel sheet
- Date formula in excel dd/mm/yyyy - Guide
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
- How to screenshot excel sheet - Guide
- Number to words in excel formula - Guide
2 responses
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.
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.
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Feb 17, 2015 at 01:58 PM
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:
BEFORE:
AFTER:
DG83
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
Feb 18, 2015 at 02:17 AM
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!
Feb 17, 2015 at 04:25 AM