Splitting a Cell

[Roast]

Hello,
I have a Cell that contains first and last name data. I would like to
split this one cell into two cells, one with first name data and one
with last name data. I have tried doing this through a Macro, but with
no sucess. Can anyone point me in the right direction? Thank you!

 

[Frank Kabel]

Hi
use 'Data - Text to columns' for this

 

[Roast]

Frank,

Thanks for your reply, it worked great!

Hi
use 'Data - Text to columns' for this