| 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? |
| 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) | |||
Threaded Mode
