You'll need 2 new cells: one to hold the 3 characters & one to hold the 2
characters.

In A2 use the formula
=right(trim(A1),2)

In the cell where you want the 3 character string use the formula
=left(trim(A1),3)

If you want to end with just the two result cells, copy them, and use
EditPaste Special Values to paste the results asVALUES over top the
formulas. Then you can delete A1



"Colin Hayes" wrote in message
...

Hi

I have a string of 5 characters in cell A1. I need to take off the final 2
characters from the string and place them in A2 , leaving the string split
3 and 2 between the 2 cells.

Is this possible via the formula bar?

Grateful for any help.


Drno