function for truncating / fixing text

[okrob]

I have a cell with a space, then first and last initial, sometimes only
a first initial, but no space between, then last name, then a very long
string of characters behind it. The last names are all differing
lengths as well.
Example cell looks like this:

[ JB KINGSLEY S444 1000R 1500 XXXX ]

I have multiple rows of this type of data and I need a formula or
function that will strip the cell of everything but the last name and
first initial /s
The format for the new cell is LASTNAME, FIMI
OR
KINGSLEY, JB

Any help would be appreciated...
Thanks,
Rob

 

[okrob]

OK, I got my solution, for anyone interested, its located here:
http://groups.google.com/group/micr...6fa92/d2e3d6645c0ddd87?hl=en#d2e3d6645c0ddd87

Rob