gcarls is his logon name in our system and will never change. I get reports
that list things he does by his logon name and I want to convert it to his
full name.
--
John


"Mike H" wrote:

John,

How do we establish that gcarls becomes Carlson, Glen?

Why for example doesn't that same username become Carlton, Geoff or any
other variation?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"John" wrote:

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