Left function

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()-1>LEN($A$1),"",MID($A$1,COLUMN()-1,1))
Copy to the right

--
Kind regards,

Niek Otten

"Allan" <[email protected]> wrote in message
news:[email protected]...
>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