Have a look in Help at function HLOOKUP and VLOOKUP
If you come back, please tell us more about the layout of the spreadsheet
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Maria Teresa" wrote in message
...
Hello,,, Is there any way to change names to numbers? example:

teresa donato
837372 366286 (telephone buttons)

I HAVE A BIG LIST OF NAMES AND WE HAVE TO CONVERT NAMES TO NUMBERS.

I APPRECIATE ANY HELP.... ... THANKS IN ADVANCE.
--
Teresa