Left function

A

Allan

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
 
N

Niek Otten

To start in B1:
=IF(COLUMN()-1>LEN($A$1),"",MID($A$1,COLUMN()-1,1))
Copy to the right
 
D

Dave Peterson

If you have a column of these things to do, you may want to insert a bunch of
empty columns to its right and do:

Data|Text to columns
Fixed width
And draw a line between each letter

And then finish up that wizard.
 
Top