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
 
Top