Reference a cell if it starts with text or if it start with a numb

[Guest]

in cell D1 I want to reference cell A1 and return the contents of A1 only if
A1 starts with a letter or text. And if A1 starts with a number I want to
return the contents of B1 in cell D1.

I hope I made sense
Thank You
Brian

 

[Jason Morin]

=IF(ISNUMBER(LEFT(A1)*1),B1,A1)

HTH
Jason
Atlanta, GA

 

[Guest]

Hi,
Thank You very much. What does the *1 mean?

=IF(ISNUMBER(LEFT(A1)*1),B1,A1)

HTH
Jason
Atlanta, GA

 

[Max]

. What does the *1 mean?

Think it's to coerce Excel to recognize the return by
... LEFT(A1) .. as a "real" number instead of text,
if A1 does start with a number, so that ISNUMBER(..)
will return the correct result of TRUE