Hi All

Thanks for your help on this - you've solved my problem. I'm grateful
for your expertise and interest.


Best Wishes

Drno




In article ,
?B?S2V2aW4gTQ==?= writes
Hi Colin, you can use Data Text To Columns. This will split it without
having to enter any formulas and then having to paste special the values from
those formulas. On the first page of the wizard make sure you choose "Fixed
Width", click next and then you can set the column break manually, once
finished this will add 2 columns with the now parsed data, delete the first
column and you're done.

HTH,
Kevin M

"Colin Hayes" wrote:


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