View Single Post
  #2   Report Post  
Old April 24th 08, 08:32 PM posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
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)
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