Change first character in a cell
Nothing wrong with Toppers' formula.
Apparently you typed or copied incorrectly.
But I see from other post you got the job done.
Gord Dibben MS Excel MVP
On Thu, 24 May 2007 17:04:05 +0200, houghi wrote:
Apparently it contains an error.
Toppers wrote:
In a "helper" column put:
="32"& RIGHT(A1,LEN(A1)-1)
Copy down.
Copy & Paste Special=Values to remove" formula.
"houghi" wrote:
I have a list of +2000 phonenumbers and they are in the format of
012345678 but must become 3212345678, so the first 0 needs to become 32
I searched, but was unable to find a solution. Any idea?
houghi
|