Display numerical code
On Fri, 22 Dec 2006 16:56:00 -0800, catwoman
wrote:
How do I make a phrase like "cherry bed" display as a numerical code like
"0042" once it is entered into the spreadsheet?
Construct a table with the equivalences, and use one of the LOOKUP functions.
--ron
|