#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 538
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Parsing XML with VBA Peter Jamieson[_2_] Excel Programming 0 May 10th 11 04:04 AM
Parsing (again) Jim Berglund[_2_] Excel Programming 1 May 31st 10 10:49 AM
Parsing Saxman[_2_] Excel Discussion (Misc queries) 3 July 30th 07 04:36 PM
Parsing a name Budget Programmer Excel Programming 2 August 19th 06 05:13 AM
Parsing help Richard[_12_] Excel Programming 0 July 27th 03 12:50 PM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"