How to split columns with multiple lines w/in cells
 

I have complete addresses in each cell. For example, cell A1 has:

John Smith
123 Main St
Anytown, XX 12345

All lines of data are contained within a single cell. How can I split it so
I have the first line (John Smith) copied to cell B1, line 2 to C1, and line
3 to D1? I am trying to avoid the manual copy/paste method.

Thanks for any advice!

How to split columns with multiple lines w/in cells
 

Are these lines within the cell caused by using alt-enters or are they just
natural line breaks when wraptext is turned on?

If you used alt-enters to get the newline
Select the column
Data|text to columns
Delimited
Other box
type:
ctrl-j
and finish up.

ctrl-j is the same as alt-enter

Ben wrote:

I have complete addresses in each cell. For example, cell A1 has:

John Smith
123 Main St
Anytown, XX 12345

All lines of data are contained within a single cell. How can I split it so
I have the first line (John Smith) copied to cell B1, line 2 to C1, and line
3 to D1? I am trying to avoid the manual copy/paste method.

Thanks for any advice!

--

Dave Peterson

How to split columns with multiple lines w/in cells
 

Dave,

You are both a scholar and a gentleman! Thank you very much!

Ben

"Dave Peterson" wrote:

Are these lines within the cell caused by using alt-enters or are they just
natural line breaks when wraptext is turned on?

If you used alt-enters to get the newline
Select the column
Data|text to columns
Delimited
Other box
type:
ctrl-j
and finish up.

ctrl-j is the same as alt-enter

Ben wrote:

I have complete addresses in each cell. For example, cell A1 has:

John Smith
123 Main St
Anytown, XX 12345

All lines of data are contained within a single cell. How can I split it so
I have the first line (John Smith) copied to cell B1, line 2 to C1, and line
3 to D1? I am trying to avoid the manual copy/paste method.

Thanks for any advice!

--

Dave Peterson