Hello Rowan From Steved

Please ignore my ealier post to you as it has been answered
Thanks very much for your time on my issue.

"Rowan" wrote:

=IF(LEFT(A1)="1","City",IF(LEFT(A1)="2","Roskill", ""))

Regards
Rowan

"Steved" wrote:

Hello from Steved

I would like to please use only the first number as a identifier.

for example 1234, 1543, 1789, 1673 in this case the 1 will = City
for example 2234, 2543, 2789, 2673 in this case the 2 will = Roskill

Thankyou.