Excel formatting column question

50

Platinum Member
May 7, 2003
2,717
0
0
Hello, I'm trying to sort a worksheet. The first column has full names in it but I want to seperate it into two columns one with first name and other with last. Anyone know how could I do this in excel without having to go through each name. Thanks