Parsing Cells with embedded returns
 

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

Parsing Cells with embedded returns
 

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
|

Parsing Cells with embedded returns
 

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