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?