How do I move some information in one cell to another cell?

D

Deborah

I have a column of information on a worksheet. Each cell in this column
holds a number that looks like this 0408015568GH. I need to take the "GH"
and move it to another column on the same worksheet. How do I do this?
 
D

David McRitchie

Hi Deborah,

Not sure if you want the original to remain. If you don't a macro
might be better. Don't know if it is always the last two characters
but the following will handle it that way.

=LEFT(A1,LEN(A1)-2)
=RIGHT(A1,2)
 
Top