See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
I'll try this again as I accidentally hit the enter key after typing the
subject. In a spreadsheet I have all of my staff listed by their
abbreviated
names used to identify them on our server. I want to be able to convert
there abbreviated names like "gcarls" to "Carlson, Glen". I think one of
the
If formualtions will work but I'm having difficulty. Can anyone please
tell
me how to do this?
--
John