Parsing

  • Thread starter Thread starter cmiedaner
  • Start date Start date
C

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.
 
cmiedaner said:
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
Click to expand...

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)
 
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.
Click to expand...

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