Identify whether a column entry starts with a letter or a number

[O177812]

I am looking for a formula that I can add to a Custom Column to determine if each line in Column1 begins with a letter or a number.

I tried the below but it is not working:

= try if Value.Is(Number.From([Column1]), type number) then "number" else "not" otherwise "not"

Assistance is greatly appreciated.

 

[Jeffrey Mahoney]

Please try this:

Book1
	A	B	C
1			abcdefghijklmnopqrstuvwxyz
2			123456789
3
4	ladjf lajflakdjflafj		Letter
5	123		Number
6	A123		Letter
7	1wwwddd		Number
8	,87aj!		Not
Sheet2

Cell Formulas
Range	Formula
C4:C8	C4	=IF(IFERROR(SEARCH(LEFT(A4,1),Alphabet),0)>0,"Letter",IF(IFERROR(SEARCH(LEFT(A4,1),Numbers),0)>0,"Number","Not"))

Named Ranges
Name	Refers To	Cells
Alphabet	=Sheet2!$C$1	C4:C8
Numbers	=Sheet2!$C$2	C4:C8

 

[RoryA]

To test if it begins with a number:

= try if Value.Is(Number.From(Text.Start([Column1], 1)), type number) then "number" else "not" otherwise "not"