number to text
 

hi,
I want to put a number in the cell and replace it automatic to text.
i have list of custmors and every one has a code example
101 mike
102 joe
103 salma....elc
if i wrote 101 in the cell i want to give me mike and so

number to text
 

Look at VLOOKUP in help.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"willy" wrote in message
...
hi,
I want to put a number in the cell and replace it automatic to text.
i have list of custmors and every one has a code example
101 mike
102 joe
103 salma....elc
if i wrote 101 in the cell i want to give me mike and so