Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 24th 08, 07:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 2
Default Parsing formatted data

I received a spreadsheet with the address already pre-formatted for a label
but I need to parse that data into individual fields. The pre-formatted data
has a next line/carriage return at the end of each line. How do I do a parse
when the delimiter is several carriage returns within a single cell?

  #2   Report Post  
Old April 24th 08, 08:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Parsing formatted data

If the delimiter is the alt-enter (like you use when you force a new line in a
cell), you can try this:

Select the single column range to parse.
Data|Text to columns (xl2003 menus)
delimited
and check other
Use ctrl-j (hold the control key when you hit lower case j)

And finish up.

Does it work?

Tufts wrote:

I received a spreadsheet with the address already pre-formatted for a label
but I need to parse that data into individual fields. The pre-formatted data
has a next line/carriage return at the end of each line. How do I do a parse
when the delimiter is several carriage returns within a single cell?


--

Dave Peterson
  #3   Report Post  
Old April 24th 08, 08:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 2
Default Parsing formatted data

Thanks Dave. Worked like a charm! I appreciate the help.

Phillip

"Dave Peterson" wrote:

If the delimiter is the alt-enter (like you use when you force a new line in a
cell), you can try this:

Select the single column range to parse.
Data|Text to columns (xl2003 menus)
delimited
and check other
Use ctrl-j (hold the control key when you hit lower case j)

And finish up.

Does it work?

Tufts wrote:

I received a spreadsheet with the address already pre-formatted for a label
but I need to parse that data into individual fields. The pre-formatted data
has a next line/carriage return at the end of each line. How do I do a parse
when the delimiter is several carriage returns within a single cell?


--

Dave Peterson

  #4   Report Post  
Old April 24th 08, 09:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,389
Default Parsing formatted data

Hi DP,
Amazing!
How are mere mortals supposed to know this? I can't find it in the Help.
Regards - Dave.

"Dave Peterson" wrote:

If the delimiter is the alt-enter (like you use when you force a new line in a
cell), you can try this:

Select the single column range to parse.
Data|Text to columns (xl2003 menus)
delimited
and check other
Use ctrl-j (hold the control key when you hit lower case j)

And finish up.

Does it work?

Tufts wrote:

I received a spreadsheet with the address already pre-formatted for a label
but I need to parse that data into individual fields. The pre-formatted data
has a next line/carriage return at the end of each line. How do I do a parse
when the delimiter is several carriage returns within a single cell?


--

Dave Peterson

  #5   Report Post  
Old April 24th 08, 09:27 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Parsing formatted data

You're too young!

Back in the caveman days of pcs, there was DOS and there were text editors (aka
stoneage wordprocessors). Lots of text editors reacted to the ctrl-j to insert
a line feed (ctrl-n forced a page break, IIRC).

If you hang around these here newsgroups long enough, you'll see people suggest
using alt-0010 (using the number pad keys).

ctrl-j is the equivalent, but it's easier to explain and do.

======
You may find some stuff on the web like:

We all were^h^h^h^hare happy.

^h was the destructive backspace.
^g was the bell character (really!)
^m was the carriage control (different from line feed)
if ^l was sent to the printer, it ejected the page.

And people think Windows is a pain to learn <hehehe


Dave wrote:

Hi DP,
Amazing!
How are mere mortals supposed to know this? I can't find it in the Help.
Regards - Dave.

"Dave Peterson" wrote:

If the delimiter is the alt-enter (like you use when you force a new line in a
cell), you can try this:

Select the single column range to parse.
Data|Text to columns (xl2003 menus)
delimited
and check other
Use ctrl-j (hold the control key when you hit lower case j)

And finish up.

Does it work?

Tufts wrote:

I received a spreadsheet with the address already pre-formatted for a label
but I need to parse that data into individual fields. The pre-formatted data
has a next line/carriage return at the end of each line. How do I do a parse
when the delimiter is several carriage returns within a single cell?


--

Dave Peterson


--

Dave Peterson


  #6   Report Post  
Old April 24th 08, 09:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,389
Default Parsing formatted data

Hey, thanks for the history lesson. I was a computer newbie in Dos days. My
first PC ran Windows 3.1!! Dos was just the weird stuff in the background. I
quickly discovered that if I played there, I could mess up real fast.
Regards - Dave.
  #7   Report Post  
Old April 24th 08, 09:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Parsing formatted data

And now with the speed of the new pcs, you (ahem, and me!) can mess up even
faster!

Dave wrote:

Hey, thanks for the history lesson. I was a computer newbie in Dos days. My
first PC ran Windows 3.1!! Dos was just the weird stuff in the background. I
quickly discovered that if I played there, I could mess up real fast.
Regards - Dave.


--

Dave Peterson


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
Help me parsing Data and Organizing dumb4ever Excel Worksheet Functions 0 October 13th 06 04:39 PM
Parsing Data with Javier Excel Discussion (Misc queries) 0 June 27th 06 06:21 PM
Help With Parsing Data Saxman Excel Discussion (Misc queries) 5 December 27th 05 02:39 PM
Parsing Data Saxman Excel Discussion (Misc queries) 4 December 8th 05 08:31 AM
Data parsing question Dan Neely Excel Worksheet Functions 0 July 19th 05 12:40 AM


All times are GMT +1. The time now is 12:43 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017