Formulate cell either text, number or blank

Closed

cabdoo Posts 1 Registration date Saturday January 30, 2010 Status Member Last seen January 31, 2010 - Jan 31, 2010 at 05:46 AM
rizvisa1 - Jan 31, 2010 at 07:09 AM

Hello,
Am trying formulate excel cel A – like this
If cell A = 12 than is 12
if its txt then its txt
if its blank then its blank

please help me with this formula many thanks

Different dates of "end to end encryption message" on blank chat?
Encryption And Decryption - Download - Encryption and decryption
Voice message downloader - Guide
How to update dates in Excel spreadsheet: formula - Guide
Message request on instagram disappeared - Guide
Sophos free encryption - Download - Encryption and decryption

1 response

Answer 1 / 1

rizvisa1
Jan 31, 2010 at 07:09 AM

you mean like this
=IF(A1=12, 12 ,IF(ISTEXT(A1),"Text",IF(ISBLANK(A1),"Blank","None of the above")))

Similar discussions

encryption message several time in chat

using web browser page loads but screen blank

Whatsapp web "chat to myself" not working

How Can I Undo Seen Message Into Unseen Message On Instagram

Why is my Whatsapp Chat not sorted chronologically?

Similar discussions

Subscribe To Our Newsletter!