Previous Topic Next Topic

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 response

Answer 1 / 1
aquarelle Posts 5959 Registration date Saturday April 7, 2007 Status Moderator Last seen February 9, 2026 491
Oct 29, 2009 at 06:38 PM
Hi,
Try with this formula :

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

Best regards
joan
Oct 29, 2009 at 08:27 PM
Thank you so much for helping me with my IF excel formula! This is the BEST site I ever found!

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses