split contents in one cell into two cells

E

egoldwyn

i have data in a microsoft word document that is 2 long columns, seperated by
a space. when i copy and paste this into Excel, it copies it into 1 column
with a space between the numbers. how can i split this one column into 2
different columns?
 
M

mpeek99

Hey Ron,

This is a great tip. I remember in the old days when you had to write a
formula to do this.

Thanks again,
Marlene
 
Top