function for truncating / fixing text

O

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Problem with SET & REF function 0
Truncating Number Series 3
Help with text function 2
is 3rd character in a cell a space? 5
user defined function which increase consecutively while passingbelow cells 12
Separate first and last name in two columns 3
Text to Columns Question 3

Top