IF formula

Solved/Closed
joan - Oct 29, 2009 at 10:54 AM
 joan - Oct 29, 2009 at 08:27 PM
Hello,
wondering if you can help me with excel

i need a formula that shows if A1 is starts with letter then give me a that first letter. If it starts with number then give me "Home"

thanks a lot

1 reply

aquarelle
Posts
7115
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 2, 2022
491
Oct 29, 2009 at 06:38 PM
Hi,
Try with this formula :

=IF(ISNUMBER(A1),"Home",LEFT(A1,1))

Best regards
0
Thank you so much for helping me with my IF excel formula! This is the BEST site I ever found!
0