Hi. I'm using excel 2010.

My cell contains data like this : ERKDKE.

Is there a way to parse the cell so the result looks like this (4 rows) ?

ER
KD
KE

Thanks in advance.

"cmiedaner" wrote:

> Hi. I'm using excel 2010.
>
> My cell contains data like this : ERKDKE.
>
> Is there a way to parse the cell so the result looks like this (4 rows) ?
>
> ER
> KD
> KE

That's not parsing, that's just splitting a string (although how that splits
out to 4 rows I don't get, but whatever).

Look at the MID function, i.e.:
=MID(A1,5,2)

VBA can also do this, via its own version of the Mid function:
ActiveCell.Value = Mid(Range("A1").Value, 3, 2)

--
You keep running through my veins.

<(E-Mail Removed)> wrote in message
news:2f8b764e-1f60-47da-9848-(E-Mail Removed)
> Hi. I'm using excel 2010.
>
> My cell contains data like this : ERKDKE.
>
> Is there a way to parse the cell so the result looks like
> this (4 rows) ?
>
> ER
> KD
> KE
>
> Thanks in advance.

.... try:
=MID(A$1;ROW(A1)*2-1;2)
and copy down!

--
regards/pozdrav!
Berislav