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

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

Thanks Gary

"Gary''s Student" wrote:

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

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

--
Kind regards,

Niek Otten

"Allan" wrote in message
...
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

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.

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

--

Dave Peterson