Parsing

[cmiedaner]

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.

 

[Auric__]

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)

 

[b&s]

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!