See Excel Help for

=MID()
--
Gary's Student


"Allan" wrote:

I have a reference code that I wish to extract and paste into separate cells.
I know that if I use =LEFT(A1,1) will give me the first letter of my code.
If I use =LEFT(A1,2) it will put the first two letters in the same cell.
What I want is is the 2nd letter to be placed in a separte cell and the third
letter to be placed in a separate cell and so on.
Can anyone help please?
Allan