splitting data from one column into two
 

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

splitting data from one column into two
 

datatext to columns

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mariekek5" wrote in message
...
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

splitting data from one column into two
 

--Select the range ColA
--From menu DataText to ColumnsDelimitedNextSelect Space and OK

If this post helps click Yes
---------------
Jacob Skaria


"mariekek5" wrote:

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