John.

We really do want to help but your not providing sufficient information.

gcarls is his logon name in our system and will never change.

What is 'our system'?

I get reports that list things he does by his logon name

Where are these reports coming from? What is the reporting tool?

Does 'the system' or 'Excel' have a table somewhere that lists full names
and logon names? If it does you can query that table with a lookup in the way
Eduardo showed you.

In short, unless you have such a table that is available to Excel then what
your asking can't be done.


--
Mike

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


"John" wrote:

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