| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
check if the text string start with a specific character
Hi,
I want to know how do I check if the text string starts with a specific character in if statement. I used ... =IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK") But, the result for this argument returns the text string which includes "v" anywhere in the text string. I just want to the text string which begins with "v". How can I make it? |
|
#2
|
|||
|
|||
|
Try: =IF(LEFT(TRIM(A2),1)="v","OK","Not OK")
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "September21" wrote in message ... Hi, I want to know how do I check if the text string starts with a specific character in if statement. I used ... =IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK") But, the result for this argument returns the text string which includes "v" anywhere in the text string. I just want to the text string which begins with "v". How can I make it? |
|
#3
|
|||
|
|||
|
Thank you very much for your help!
"Max" wrote: Try: =IF(LEFT(TRIM(A2),1)="v","OK","Not OK") -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "September21" wrote in message ... Hi, I want to know how do I check if the text string starts with a specific character in if statement. I used ... =IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK") But, the result for this argument returns the text string which includes "v" anywhere in the text string. I just want to the text string which begins with "v". How can I make it? |
|
#4
|
|||
|
|||
|
You're welcome !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "September21" wrote in message ... Thank you very much for your help! |
|
#5
|
|||
|
|||
|
=IF(LEFT(A2,1)="v","OK","Not OK")
Vaya con Dios, Chuck, CABGx3 "September21" wrote in message ... Hi, I want to know how do I check if the text string starts with a specific character in if statement. I used ... =IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK") But, the result for this argument returns the text string which includes "v" anywhere in the text string. I just want to the text string which begins with "v". How can I make it? |
|
#6
|
|||
|
|||
|
Thank you very much for your help!
"CLR" wrote: =IF(LEFT(A2,1)="v","OK","Not OK") Vaya con Dios, Chuck, CABGx3 "September21" wrote in message ... Hi, I want to know how do I check if the text string starts with a specific character in if statement. I used ... =IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK") But, the result for this argument returns the text string which includes "v" anywhere in the text string. I just want to the text string which begins with "v". How can I make it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up a string of text within a string of text | Excel Worksheet Functions | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| Removing numbers from the beginning of a text string | Excel Worksheet Functions | |||
| Check if table contains text | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
