if a cell has a number do this if it has a letter do that

[isaac359]

i cant seem to figure out how to check a cell for any letter in the us alphabet. i want my formula to put cells together in a string, but if there is no number then it needs to add one more cell to the string. any help would be great. thanks



=IF(LEFT(G19,1)*1, C19&" "&D19&" "&E19, IF(LEFT(G19,1)*abc*, C19&" "&D19&" "&E19&" "&G19))

[AliGW]

Welcome to the forum!

Have you tried using the ISNUMBER, ISTEXT and ISNONTEXT functions?

[isaac359]

no, i have not tried that

[Phuocam]

Try:

= C19&" "&D19&" "&E19&IF(ISNUMBER(LEFT(G19,1)*1),"",G19)

[isaac359]

that is a great way to do it, but what if it is a letter?

[isaac359]

thank you, That was awesome

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.