Separate Multiple Lines in 1 Cell

**SpanishMosca** · 12-07-2011, 04:47 PM

I need to parse multiple lines in 1 cell.

For example, in A1 I have:

123 Main Road
Dallas, TX 75261
USA

I need to those multiple lines into 3 different rows in excel. So that the file can then read:

A1: 123 Main Road
B1: Dallas, TX 75231
C1: USA

Help please!!

**Haseeb Avarakkan** · 12-07-2011, 05:03 PM

Assume your multiple lines done through Al+Enter, If so select the range press Ctrl+H to activate Find/Replace.

From the keyboard numeric side (right side of the keyboard, not the top row) in Find What: type Alt+010, then Replace with "|" (without quotes).

Then do Text To columns & select other as "|" (without quotes)

**SpanishMosca** · 12-08-2011, 08:37 PM

I tried your method above, and it didn't work for me.The multiple lines were not done through Alt+Enter. They were simply exported from a program (Tableau), that automatically combined them together. Here is what my spreadsheet looks like:

A1: "123 Main St
Dallas, TX 75261
USA"
B1: Dallas
C1: TX
D1: 75261
E1: USA