Splitting data in a cell

N

Number_8

Hi,

I have a spreadsheet which has data entered into a single cell an
split onto seperate lines - they ar eaddresses. I need to get each lin
out of the cell and into a seperate cell.

How can i do it?

Thank
 
D

Debra Dalgleish

You can use Excel Text to Columns feature to split the data.

(Make a backup copy of the data before you split it)

Assuming the line breaks were created by pressing Alt+Enter --
Ensure that there are blank columns to the right of the addresses
Select the cells that you want to split
Choose Data>Text to Columns
Select Delimited, click Next
Check 'Other', and click in the 'Other' box
Hold the Alt key, and on the number keypad, type: 0010
(you won't see anything in the 'Other' box, but that's
the code for a line break character)
Click the Finish button
 
Top