Thread
:
Reconize the first digit only
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Steved
external usenet poster
Posts: 519
Reconize the first digit only
Hello from Steved
Please how do I ask the below to except the first digit in this case "Wiri"
for example 4111, 4521, 4321, 4976 and so on, will return "Wiri".
=IF(E3=4051,"Wiri","")
Thankyou
Reply With Quote
Steved
View Public Profile
Find all posts by Steved