Trouble splitting cell contents

S

scottr

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
 
D

Dave Peterson

And to specify that alt-enter character, select the Other box, remove anything
that's in that box and hit ctrl-j.
 
Top