Convert Text to Columns (Cells Include Line Breaks)

[littlefish]

I have a single column of several hundred rows of data that I would like to use the "convert text to columns" wizard, however, in addition to typical delimiters (i.e. "," and ";") these cells contain line breaks. When I run the wizard, the result is a single column of data to the point of the line break. Each individual cell has varying counts of delimiters.

I would welcome input on how to split the data into multiple columns (it's possible in some cases there could be up to eight columns needed,) accounting for three delimiters:
,
;
[line breaks]

Thanks so much in advance.

TZ

 

[alansidman]

Use the XL2BB to provide a sample of your data so that we can see exactly what you have. Make sure also for the sample data to show us what your expected results will look like.

 

[Fluff]

Select semi-colon, comma & other and in the box for other type Ctrl J

 

[sandy666]

out of curiosity
what if there is more delimiters, like: comma, semi-colon, pipe & LF ? (or more)

 

[littlefish]

This is a single cell in my xls, and the XL2BB c/p displays it with line breaks:

LA PLATA CO CO .1875 MI IN THE S/2 SW/4 O/O 320 ACRE W/2 SPACING IN SEC. 17 T32N-R6W; IGNACIO BLANCO (FC) ABEYTA NO. 17-1; .0140625 NRI

After applied delimiters, this cell would appear in six consecutive columns:

LA PLATA CO CO .1875 MI IN THE S/2 SW/4 O/O 320 ACRE W/2 SPACING IN
SEC. 17 T32N-R6W
IGNACIO BLANCO
(FC)
ABEYTA NO. 17-1
.0140625 NRI

 

[littlefish]

Select semi-colon, comma & other and in the box for other type Ctrl J

I was in the midst of pasting the sample data when you responded. It came out perfect. Thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback