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

IF formula
Spreadsheet formula - Articles
Excel @ in formula ✓ - Forum - Excel
Little alchemy formulas - Guide
1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
Logitech formula vibration feedback wheel driver windows 10 - Download

1 reply

Answer 1 / 1

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

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!

Subscribe To Our Newsletter!