Separating names in a column

[Ray K]

I have a column containing 133 names in this order: First, space, Last.
Examples: John Smith, Jane Doe.

I would like to insert a new column, then leave either of the names in
the existing column and move the other one to the new column.

Any ideas?

Many thanks.


Ray

 

[Martin]

Hello

Try Data ! text to columns.

 

[Don Guillett]

data>text to columns>>>

 

[Ray K]

Hello

Try Data ! text to columns.

Thanks, Martin. That did the job.

Ray