Try selecting the column of data to parse and run this:

Sub Macro1()
Selection.TextToColumns Destination:=Selection, DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar
_
:=Chr(10)
End Sub


--
Jim
"sportsguy" wrote
in message ...
|
| The SOX rocket team passed us a spreadsheet that has columns that need
| to be parsed into individual columns.
|
| The column contains embedded CRLF characters and contains variable
| numbers of characters separated by CRLF characters.
|
| any suggestions, code or otherwise?
|
| thanks in advance
|
| sportsguy
|
|
| --
| sportsguy
| ------------------------------------------------------------------------
| sportsguy's Profile:
http://www.excelforum.com/member.php...o&userid=24771
| View this thread: http://www.excelforum.com/showthread...hreadid=529663
|