excel formula

[Ron99]

hi,

I have list of numbers

GS012345
GS012566
GS012589

I want to add letter X after every 4th digit

for example - GS01X2345, GS01X2566, GS01X2589.

Is this possible ?

Thank you

 

[Ingolf]

Hi,

You can use tihs formula =LEFT(A1;4)&"X"&RIGHT(A1;LEN(A1)-4) replace A1 with cell you have that numbers

 

[p45cal]

Excel Workbook
	A	B
1	GS012345	GS01X12345
2	GS012566	GS01X12566
3	GS012589	GS01X12589
Sheet2

http://www.excel-jeanie-html.de/index.php?f=1

 

[Ron99]

Thanks guys...both works

 

[Ingolf]

Glad to help you!

 

[Zaigham]

hi,

I have list of numbers

GS012345
GS012566
GS012589

I want to add letter X after every 4th digit

for example - GS01X2345, GS01X2566, GS01X2589.

Is this possible ?

Thank you

I think you haven't seen the results minutely. With a little change in formula please try this.

=LEFT(A1,4)&"X"&RIGHT(A1,LEN(A1)-4)

OR

=LEFT(A1,4)&"X"&MID(A1,5,999)

 

[mikerickson]

The replace function will do that
=REPLACE(A1,5,0,"X")

With longer strings (eg "A23456789" >> "A234x5678x9") one should apply it recurivly from the end of the string
=REPLACE(REPLACE(A1, 9, 0, "x"), 5, 0, "x")