PC Review


Reply
 
 
cmiedaner@msn.com
Guest
Posts: n/a
 
      20th Aug 2012
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.
 
Reply With Quote
 
 
 
 
Auric__
Guest
Posts: n/a
 
      20th Aug 2012
"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.
 
Reply With Quote
 
 
 
 
b&s
Guest
Posts: n/a
 
      20th Aug 2012
<(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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Parsing HTML in .Net (Document Object Model Parsing) Jarod_24 Microsoft VB .NET 0 4th Apr 2006 06:23 PM
XP SP2 creates IE 6 parsing error =?Utf-8?B?QnJpYW4=?= Windows XP Help 1 17th Nov 2004 05:23 PM
XP SP IE error message re: PARSING =?Utf-8?B?Ym9ubGV5?= Windows XP Help 1 15th Nov 2004 06:39 PM
error parsing voucher =?Utf-8?B?cmVuZHVy?= Windows XP Help 2 7th Apr 2004 02:57 PM
parsing error in Search =?Utf-8?B?YmFza2V0MjE=?= Windows XP Help 1 27th Feb 2004 07:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:09 AM.