TEXT issues

[Jafferi]

The following is the Row of codes that states like INVMP etc.

How can I formulate in a cell to tell me that when the code row is a text,
give me result 'Clearance'

For example
Cell A2 is shown as "INVMP". A formula that states results in cell A1
'Clearance' and if A2 is blank, it will show as blank and if A2 is a numeric
e.g. 12222 and result in A2 will show as 12222.



Code
INVMP
INVMP
INVTT
INVTA

 

[Al Campagna]

Jafferi,
This newsgroup deals with Microsoft Access, a relational database
application.
Sound like your question is referring to a spread sheet problem.
You'll have better lucj posting in a newsgroup devoted to your
spredahseet application.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."