TEXT issues
 

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

TEXT issues
 

hi
i may be a little confused but try this and see if it is what you want....
=IF(A2="","",IF(ISTEXT(A2),"Clearence",A2))

regards
FSt1

"Jafferi" wrote:

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

TEXT issues
 

FSt1.. THANK YOU VERY MUCH! This helps

"FSt1" wrote:

hi
i may be a little confused but try this and see if it is what you want....
=IF(A2="","",IF(ISTEXT(A2),"Clearence",A2))

regards
FSt1

"Jafferi" wrote:

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