Separate Columns by Line Break

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a set of exported data separated by line breaks. In other words, I
would like to separate the data into columns based on where the line breaks
fall. However, I cannot figure out how to do this. Does anyone have a
suggestion.
 
Frank,

Thanks for your response. I tried that function. However, I don't know how
to make it do it for line breaks. I tried "Delimited" and then "Other," but
I don't know how to put a line break in that space.

Linton
 
Frank,

That did enter in a line break. But, I guess I was wrong in assuming that
my data was separated by line breaks. The data was exported from FileMaker
into a .CSV file. The data in the field is separated by boxes (e.g. []). I
just assumed that these boxes were line breaks. Is there anything else that
they could be? Thanks again.

Linton
 
Hi
try ALT+0013

--
Regards
Frank Kabel
Frankfurt, Germany

Frank,

That did enter in a line break. But, I guess I was wrong in assuming
that my data was separated by line breaks. The data was exported
from FileMaker into a .CSV file. The data in the field is separated
by boxes (e.g. []). I just assumed that these boxes were line
breaks. Is there anything else that they could be? Thanks again.

Linton

Frank Kabel said:
Hi
try entering ALT+0010
Click to expand...
Click to expand...
 
In the "other" box hold ALT and hit 0010 or 0013 on the NumPad.

You won't see anything in box, but it is there.

Then hit Finish.

Gord Dibben Excel MVP
 
That worked ok for me with alt-0010--but not alt-0013.

For the OP:

For alt-0013, I used a helper column and a formula like:
=SUBSTITUTE(A1,CHAR(13),"|")

Then I dragged this down and did a copy|paste special|values

Then I used data|text to columns (delimited by |).

(use a character that doesn't appear in your data in that formula.)

And still for the OP: Get a copy of Chip Pearson's CellView addin:
http://www.cpearson.com/excel/CellView.htm

And it'll tell you what those characters are.
 
Back
Top