Hi,

Use the Left function

=left(cell reference,1)

Regards,

Ashish

"Steved" wrote:

Hello from Steved

Numbers 1234, 1543, 1674, 1896 A formula please to use 1st digit to be
identifier
which in this case is 1 so will return the value City

Numbers 2234, 2543, 2674, 2896 A formula please to use 1st digit to be
identifier
which in this case is 2 so will return the value Roskill

Thankyou.