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

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
|

Great answer,

thank you very much!

sportsguy


--
sportsguy
------------------------------------------------------------------------
sportsguy's Profile: http://www.excelforum.com/member.php...o&userid=24771
View this thread: http://www.excelforum.com/showthread...hreadid=529663