Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line Breaks in cells - Mac OS X Leopard
Using Excel 2004 for Mac v11.5
I have a spreadsheet delivered to me from a 3rd party which contains an address list. The address cell has the city state and zip all together in one cell apparently separated by a line break character because the wrap text causes the cell to divide into multiple lines with the city state and zip on separate lines - there are most likely 2 line breaks because there is a blank line between each data line. Is there any way to automatically separate the three fields into 3 columns? thanks, bill plunkett |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line breaks in my cells... | Excel Discussion (Misc queries) | |||
Line breaks | Excel Discussion (Misc queries) | |||
Line breaks in Excel? | Excel Discussion (Misc queries) | |||
Inserting line breaks into merged text cells. | Excel Discussion (Misc queries) | |||
Line breaks | Excel Worksheet Functions |