splitting data from one column into two

  • Thread starter Thread starter mariekek5
  • Start date Start date
M

mariekek5

Hi,

Is it possible to split text or other type of data from one column into two?

Two examples:

A
Brown dog
Yellow bird
etc..

into:
A B
Brown dog
Yellow bird

Thanks in advance.

Marieke
 
--Select the range ColA
--From menu Data>Text to Columns>Delimited>Next>Select Space and OK

If this post helps click Yes
 

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

merging text from two cells 2
changing capslock letters into normal letters 4
Search Data from one Workbook and copy it into another Workbook 1
Duplicate Words in a Cell 2
2007 Formula Needed to Update Table Values 8
Concatenate All Possible Combinations 4
can I sort text data into bins? 5
naming a column 3

Back
Top