Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help me parsing Data and Organizing | Excel Worksheet Functions | |||
Parsing Data with | Excel Discussion (Misc queries) | |||
Help With Parsing Data | Excel Discussion (Misc queries) | |||
Parsing Data | Excel Discussion (Misc queries) | |||
Data parsing question | Excel Worksheet Functions |