Does anyone know how to code in whether or not a cell begins with a number or a character?
I pulled this from an different website, but doesn't seem to solve my problem:
Thanks
I pulled this from an different website, but doesn't seem to solve my problem:
Code:
[COLOR=#242729][FONT=Consolas]=IF(ISNUMBER(VALUE(LEFT(Q2,1))),"Non-Alpha","Alpha")[/FONT][/COLOR]
Thanks