Thread: replace letters for numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default replace letters for numbers
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
Reply With QuoteReply With Quote