can i create multiple columns from the info in one cell
 

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.??

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


"HawaiianTux" wrote:

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.??

Thanks....that's waht i was looking for. Very easy!!!

"Duke Carey" wrote:

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


"HawaiianTux" wrote:

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.??