Excel Question

[morocco31477]

How would I divide one cell into two cells? For example, in column A, I have:

abcdefg blah blah blah blah

xoxoxo blah blah dee dee dah

ect ect

How would I divide this into two different columns? I'm using Microsoft Office '07.

[IcemanND]

how is it you are determining where the split is.

[morocco31477]

how is it you are determining where the split is.

Oh, there are like four spaces after the first set of letters, but I guess this forum auto-corrects extra spaces. So, let's ignore the periods:

abcdefg.....blah blah blah blah

xoxoxo.....blah blah dee dee dah

ect ect

Like that, where the five periods are.

[morocco31477]

Nevermind, I figured it out. Thank you though.

[IcemanND]

select the desired cells/column.

On the Data tab

in the Data tools group

click text to columns

complete the wizard as desired.