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
 
Back
Top