Trouble splitting cell contents
 

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

Trouble splitting cell contents
 

Use the Text-to-Columns feature with ALT-ENTER as the separator character
--
Gary''s Student - gsnu200715


"scottr" wrote:

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

Trouble splitting cell contents
 

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



Gary''s Student wrote:

Use the Text-to-Columns feature with ALT-ENTER as the separator character
--
Gary''s Student - gsnu200715

"scottr" wrote:

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


--

Dave Peterson