I am really computer (dumb)! I want to create a formula so when I type in the
#1 John Smith will be entered into that cell.

Do you want:

This return in only one cell or any cell in a range of cells?

Different returns for different numbers enterd?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"woodcb" wrote in message
...
I am really computer (dumb)! I want to create a formula so when I type in
the
#1 John Smith will be entered into that cell.