Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
string/char CONTAINS function?
i am trying to determine if a cell has a partial value in it, for example
cola colb john smith 1 john brown 2 bob smith 3 carly simon 4 john clark 5 tom smith 6 processing column a, top to bottom,for 'smith' would return 10, or 'john' would return 8. any help would be appreciated. btw, if column a is a currency field can you find the '$'. i tried the search function on that kind of field and it doesnt think it is text so struck out. can you 'convert' a cell to text for comparison purposes without having to go change the true underlying format? thanks. jim microsoft.public.excel.worksheet.functions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |