View Single Post
  #1   Report Post  
OhhAhh
 
Posts: n/a
Default Replacing characters

I have a sheet with old phone numbers on it. The numbers all have a leading
3 (ie 3476) which I want to replace with a 0 (ie 0476). Of course if I do a
regular find and replace it will replace all 3's within the numbers not just
the leading one. Can someone out there tell me what the best way to achieve
this is.

Thanks

Graeme