Prev: converting email address names in a range of cells to real names
Next: Excel Code
From: John on 19 May 2010 10:34
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
From: T. Valko on 19 May 2010 10:43
See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"John" <John(a)discussions.microsoft.com> wrote in message
news:D41F24CA-58C4-4F49-B40D-38659A912428(a)microsoft.com...
> 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


From: Mike H on 19 May 2010 10:47
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
From: Eduardo on 19 May 2010 10:48
Hi,
Let's assume you have a list of full names in sheet2 in column A and the
abbreviate name in column B, then in sheet 1 you have the abbreviate names in
column A, so in column B enter

=index(sheet2!$A$1:$A$10000,match(a1,$B$1:$B$10000,0))

"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
From: John on 19 May 2010 10:58
To be clearer, what really want to do is find each incidence of "gcarls" in a
column and have each instance converted/replaced with "Carlson, Glen"
--
John


"Eduardo" wrote:

> Hi,
> Let's assume you have a list of full names in sheet2 in column A and the
> abbreviate name in column B, then in sheet 1 you have the abbreviate names in
> column A, so in column B enter
>
> =index(sheet2!$A$1:$A$10000,match(a1,$B$1:$B$10000,0))
>
> "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
 |  Next  |  Last
Pages: 1 2 3
Prev: converting email address names in a range of cells to real names
Next: Excel Code