| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find
123FF+,456 ,789FF+ (Text format )
How can i find the "FF" and return the number before "FF" ?I had try to use Find method in excel, but it only can help me to find out first "FF". |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find
=MID(A1,FIND("FF",A1)-1,1)
Regards, Stefi KK ezt Ă*rta: 123FF+,456 ,789FF+ (Text format ) How can i find the "FF" and return the number before "FF" ?I had try to use Find method in excel, but it only can help me to find out first "FF". |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find
Or, if you want it as a VBA line:
?MID(range("A1"),instr(1,range("A1"),"FF")-1,1) Regards, Stefi KK ezt Ă*rta: 123FF+,456 ,789FF+ (Text format ) How can i find the "FF" and return the number before "FF" ?I had try to use Find method in excel, but it only can help me to find out first "FF". |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find
I means save two value before "FF".
"KK" wrote: 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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find
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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find
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? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find
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? |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find
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? |
|
#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? |
| Reply |
| 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 | |||
Linear Mode
