Hey all.

I have a column with users first name and last name inside the same
single column

What I want to do is split the data, into 2 columns and I can do this.

Problem is, not all the data is the same, for instance

John Doe
Dr John Doe
John Doe III

etc...

Therefore, I am wondering if there is a way to sort the data so the
column will show the fields with FirstName Lastname first and then sort
the exceptions in no parciular order.

Thanks
Caden


--
Caden
------------------------------------------------------------------------
Caden's Profile: http://www.excelforum.com/member.php...o&userid=27252
View this thread: http://www.excelforum.com/showthread...hreadid=467583