Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parsing
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parsing
"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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parsing
wrote in message
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing XML with VBA | Excel Programming | |||
Parsing (again) | Excel Programming | |||
Parsing | Excel Discussion (Misc queries) | |||
Parsing a name | Excel Programming | |||
Parsing help | Excel Programming |