shifting alphabets within a cell

[gerard83]

Hi,

I have a question. I have a cell that reads SD12345678. Is there a formular to make it read S12345678D instead?

Would apprectiate if someone could provide me with some help here.

[Special-K]

=left(a1,1)&mid(a1,2,1)&(right(a1,len(a1)-2)

[okili]

hi gerard83,
your issue is to move the second letter (or symbol) to the end of the cell's value?
without VBA it can be done by left and mid formulas. So if you have "SD12345678" in A1 cell, type this formula : "=LEFT(A1,1)&MID(A1,3,LEN(A1))&MID(A1,2,1)" in B1 and you will get "S12345678D" in B1 cell.

[gerard83]

hey thanks so much!! that works exactly like how i wanted it!! =)