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:

	Column-1	Column-2	Column-3	Column-4	Column-5
Row-1	Text-Block	Text-Block	Text-Block	Text-Block	Text-Block
Row-2	Text-Block	Text-Block	Text-Block	Text-Block	Text-Block
Row-3	Text-Block	Text-Block	Text-Block	Text-Block	Text-Block

<tbody>
</tbody>

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.