Hello!I have some 9digit numbers and i have to enter the number 9 afther the fourth digit. Example :
50200491 - turned into 502900491
If someone could help would be much appreciated!I have to modify 1280k lines!
Hello!I have some 9digit numbers and i have to enter the number 9 afther the fourth digit. Example :
50200491 - turned into 502900491
If someone could help would be much appreciated!I have to modify 1280k lines!
Last edited by alogoc; 07-20-2009 at 05:03 AM.
Hi,
try this:
=LEFT(A1,4)&"9"&RIGHT(A1,5)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Hey,thanks for taking time to answer my quesion.I tried your formula but it get's me a syntax error
From what i've understand the problem must me on 2nd part "(&RIGHT(A1,5)"
Do you have semi colons as separators?
If so,
Perhaps this...
=LEFT(A1;4)&"9"&RIGHT(A1;5)
Yup that was the problem!Thanks for taking time to answer this!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks