Splitting data in a cell

  • Thread starter Thread starter Number_8
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting up information in a cell 1
Spliting a cell with multiple entries into seperate rows 1
Splitting Data from One Worksheet to Many Automatically 3
Split data in field on character return 0
Splitting cells in Excel 2007 1
splitting a cell in to three 4
Split cell based on uppercase letter 2
VBA Multiple Line handling with Split() 1

Back
Top