Trouble splitting cell contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any help would be greatly appreciated. I have a file that was imported from
our house ADP program. Some cells were brought in with 3 lines of info in 1
cell.

453
453
1

This previous info was all in cell b1. What is the easiest way to split
this information so I can pull information from here to another spreadsheet?

Thanks again for help
 
Use the Text-to-Columns feature with ALT-ENTER as the separator character
 
And to specify that alt-enter character, select the Other box, remove anything
that's in that box and hit ctrl-j.
 
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 cell contents into 2 cells 1
HELP! Split cell contents to new rows 7
weeding out info from cells 1
Splitting cells in Excel 2007 1
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells 1
Reverse Concatenation (Splitting Single Cell Data into Multiple Ce 5
print excel spreadsheet splitting cell contents on multiple pages 2
copying cells with similar text 5

Back
Top