reformat text in a cell

J

james

I have 2000+ cells that look like this:

UK00001 Geddy Lee
2112 Bytor Ln

GLENVIEW, IL 60025-1522


Is there a simple way to add a space after each line? right now when i paste
it into a word doc, it shows like this : UK00001 Geddy Lee2112 Bytor
LnGLENVIEW, IL 60025-1522

I would like to REFORMAT every cell to look like this with spaces in between
to make it readable: UK00001 Geddy Lee 2112 Bytor Ln GLENVIEW, IL
60025-1522


any suggestions?
 
Top