Parsing Cells with embedded returns

S

sportsguy

The SOX rocket team passed us a spreadsheet that has columns that nee
to be parsed into individual columns.

The column contains embedded CRLF characters and contains variabl
numbers of characters separated by CRLF characters.

any suggestions, code or otherwise?

thanks in advance

sportsgu
 
J

Jim Rech

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
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?action=getinfo&userid=24771
| View this thread: http://www.excelforum.com/showthread.php?threadid=529663
|
 
Top