ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Find (https://www.excelbanter.com/excel-programming/431719-find.html)

KK

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".

Stefi

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".


Stefi

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".


KK

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?

KK

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?


Stefi

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?


KK

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?


Stefi

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?


KK

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?


Stefi

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?



All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com