can i create multiple columns from the info in one cell

H

HawaiianTux

I copied a pasted info from a word document to excel. it copied as follows:

AAAAA BBBBBB CC D EEEEE FFFFF GGG

all in one column (column A). Is it possible to take that info and separate
it into colums so that each has its own column - i.e. AAAAA in column
A....BBBBBB in column B.....CC in column C...etc.??
 
D

Duke Carey

Highlight the single column, then use the Data | Text to Columns menu option.
There are easy to follow prompts
 
Top