Need Excel help changing full name into first/last

[Axel]

There has got to be a quick way to do this, but I can't find it -

I've got columns of names that are the person's first name - a space - and their last name, and I need this in 2 columns - first name and last name -

Anyone know a macro or quick & dirty way to pull this off? - I've got close to 2000 names and don't have a desire to re-type them all.....

[Axel]

Found it -

Data - Text to Columns - delimited -

it parses out the name into seperate columns and did 98% of the work for me -

Had a column of names while had the first & last in the same field - had to split this out for a macro to run correctly.....

just had to figure out where to look....

Another one for the archives....