Thanks again Tom...
That works too. I have a decision to make as to which solution to use.
Yours may suit me better in that I won't have to worry about making
sure there is access to the addin that Ron suggested. The spreadsheet
will be viewed on thin clients (only excel reader) across many
facilities.
Rob



Tom Ogilvy wrote:
I thought you said you only wanted the first initial. So you can do

=MID(A1,FIND(" ",A1,2)+1,FIND(" ",A1,5)-FIND(" ",A1,2)-1)&",
"&Trim(MID(A1,2,2))


--
regards,
Tom Ogilvy

"okrob" wrote in message
ups.com...
Thanks Tom
Changed the last &MID(A1,2,1) to &MID(A1,2,2) to get both initials, but
when I do that, if there's only one initial present, I get the space
before the last name...

The cell looks like this when there is only one initial present:
[ J KINGSLEY S444 1000R 1500 XXXX ] <== two spaces
between initials and the last name...

Again, with both initials, one space...
[ JB KINGSLEY S444 1000R 1500 XXXX ]
It's just how the data comes into excel from a terminal emulator screen
copy.

Rob



Tom Ogilvy wrote:
=MID(A1,FIND(" ",A1,2)+1,FIND(" ",A1,5)-FIND(" ",A1,2)-1)&",
"&MID(A1,2,1)

--
Regards,
Tom Ogilvy


"okrob" wrote in message
ps.com...
Can someone take a look at this post:
http://groups.google.com/group/micro...953084d4a98d93

The group isn't very active today and I need help as soon as
possible...
Thanks,
Rob