split contents in one cell into two cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
use 'Data - Text to columns' for this and use the space as delimiter
 
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
 
You must log in or register to reply here.

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

Similar Threads

Split column contents (de-concantenate) 7
Dividing existing content into two cells 2
Split individual cells? 2
Split Cells 2
HELP! Split cell contents to new rows 7
Splitting cell contents into 2 cells 1
Split cells across multiple columns 1
Splitting Data from One Worksheet to Many Automatically 3

Back
Top