It will, which is where it fails.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R.VENKATARAMAN" wrote in message
...
I wonder whether it will change 2432 as 2402

Aladin Akyurek wrote in message
...
=SUBSTITUTE(A1,"3","0",1)

OhhAhh wrote:
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