| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find
You are welcome! Thanks for the feedback!
Stefi KK ezt Ă*rta: Thanks a lot !!!Stefi you been great help !! KK "Stefi" wrote: Sub test() NoOfFF = Len(Range("A1")) - Len(Replace(Range("A1"), "FF", "")) / 2 FFpos1 = InStr(1, Range("A1"), "FF") var_a = Val(Mid(Range("A1"), 1, FFpos1 - 1)) FFpos2 = InStr(FFpos1 + 2, Range("A1"), "FF") commapos = InStrRev(Range("A1"), ",", FFpos2) var_b = Val(Mid(Range("A1"), commapos + 1, FFpos2 - commapos - 1)) End Sub Regards, Stefi KK ezt Ă*rta: Ya , i would like to save variable a as 123 , and variable b as 789 .But the string no always 3 character long , sometime will be 2 or one , but each 123FF,456,789FF is divide by a comma. "Stefi" wrote: Number off FFs: NoOfFF = Len(Range("A1")) - Len(Replace(Range("A1"), "FF", "")) / 2 Do you mean that var1 should be 123, var2 should be 789? If so, are these substrings always 3 character long? Do you want the variables be strings os numbers? Stefi KK ezt Ă*rta: Hi Stefi , Thanks for your help !!!^^ But if i would like save the two value into 2 variable , is it possible ? and have any function to count how many "FF" in a cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - delete the remainder of the text in the cell after my Find | Excel Programming | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
Threaded Mode
