Setting Custom Delimiters for Importing Text into Worksheet

[CaseyCayce]

I have lengthy text in an MSWord document I need to import into an Excel worksheet. This body of text needs to be distributed across 5 columns, then begin new rows. The text is such that there are line breaks occurring within text intended for each cell, so I need for Excel to ignore line breaks, as those normally begin filling the next cell.


My question is, how do I impose custom delimiters so that text will break across columns, then another delimiter causing the text to begin a new row, like this:


[TABLE="width: 600, align: left"]
<tbody>[TR]
[TD="align: center"]
[/TD]
[TD="align: center"]Column-1[/TD]
[TD="align: center"]Column-2[/TD]
[TD="align: center"]Column-3[/TD]
[TD="align: center"]Column-4[/TD]
[TD="align: center"]Column-5[/TD]
[/TR]
[TR]
[TD="align: center"]Row-1[/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[/TR]
[TR]
[TD="align: center"]Row-2[/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[/TR]
[TR]
[TD="align: center"]Row-3[/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[TD="align: center"]Text-Block [/TD]
[/TR]
</tbody>[/TABLE]









In other words: I need to import a body of text into Excel, having Excel ignore line breaks/returns in the text, but recognize custom delimiters to break the text to fill the worksheet as shown above.


Any help would be appreciated.


Thanks.


Cayce

 

[yky]

To ignore line breaks is easy. In Word, you just do a Find/Replace to replace line breaks with something else, a "^", maybe, which can be used as the delimiter in Excel.