data=Text to columns

--
Regards,
Tom Ogilvy

"Matt" wrote in message
...
Hi,

I have a column that has the first and last name separated by a space in
that column. Is there a way to write a macro to place the last name in a
different column?

Thanks!!

-Matt