I have a Calc SS with numbers 1 thru 32 entered randomly through several columns. I want to replace each number to a corresponding name. For example, replace 3 with ABC. When I used the find and replace function, all numbers containing a 3, e. g. 13, 23, 31, are selected and replaced. Any suggestions would be appreciated.
Tick the box Entire cells
If it is greyed out, then untick Regular expressions first.
1 Like
Thanks so much, EarnestAl. That worked!! Much appreciated.
If you had started with 32 and worked in descending order of Find value, you should have been able to achieve what you want.
… assuming a name cannot contain digits
Hmm, interesting robleyd. I’ll try that too. Thanks so much!!
rd