what about a coide to chage all "a' to number 2 and "z" to number 9?

like that one that right the currencys?

$100 - one hundred dollars

thanks man

--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Gary''s Student" escreveu:

Say we have a list of names in column A from A1 thru A2000. The names all
appear in a much smaller list from C1 thru C50. In D1 thru D50 are the
equivalend numbers for each name.

In B1 enter:
=VLOOKUP(A1,$C$1:$D50,2,FALSE) and copy down thru B2000

Then copy column B and Paste/Special/Values onto column A.

Finally column B can be cleared.
--
Gary''s Student - gsnu200856


"Marcelo" wrote:

Gary, she is looking to replace each letter for a number, how vlookup will
look for each one?

thanks

--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Gary''s Student" escreveu:

If you have a translation table that gives a number for each name, then you
can use VLOOKUP().

See:

http://support.microsoft.com/default.aspx/kb/181213
--
Gary''s Student - gsnu200856


"Maria Teresa" wrote:

I have a big list of names that i need to replace for numbers .... is there
any way to do this in excel?
example:

Eduardo Gomez 3382736 46639 (according telephone buttons numbers)

Anny help.....very appreciated! Thanks for your time.
--
Teresa