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
|