|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 25th, 2009, 02:30 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
June 25th, 2009, 02:36 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reconize the first digit only
Try:
=if(left(e3,1)="4","Wiri","") Regards, Fred. "Steved" wrote in message news  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
|
|
#3
June 25th, 2009, 02:48 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reconize the first digit only
Do you mean
=IF(LEFT(E3,1)="4","Wiri","") If this post helps click Yes --------------- Jacob Skaria "Steved" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
