Removing hard returns

J

Janet

I have a cell with a complete address, spaced with a hard return:
555 Main Street
Anywhere, USA 80101

And want the address to be separated to different cells. Any ideas?
 
G

Gary''s Student

Select the cell and pull-down:

Data > Text to Columns... > Delimited > Next
check Other and in the character box touch CNTRL-j
and then Finish
 

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

Top