Checks whether a value is text or number

R

robertc

I want to make a function which returns a value if an entry is text and
another value if the entry is a number.

For example:

If A1=text, "True", If A1=number, "False
 
P

Philip J Smith

Try.

=if(cell("type",A1)="l","Message for Label","Message for Number")

"l" is lower case L.

"Type" Text value corresponding to the type of data in the cell. Returns "b"
for blank if the cell is empty, "l" for label if the cell contains a text
constant, and "v" for value if the cell contains anything else.
 
Top