splitting data from one column into two

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
 
J

Jacob Skaria

--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
How to convert at single colum list into a multi column table 1
changing capslock letters into normal letters 4
Generated text copies into another template 0
Duplicate Words in a Cell 2
Two columns followed by single page-width column on same page 0
subtotal data from 2 columns into 3rd column 1
How to center adjust text above and image in a two column document. 1

Top