I am unable understand the following code. Please explain me about this chain formula and explain about the purpose these many quatation marks.
str = Sheets("Sample1").Range("B" & i).Value
Sheets("Sample3").Range("C" & i).Value = "=IF(ISERROR(FIND(" & """-""" & "," & """" & _
str & """" & ",FIND(" & """-""" & "," & """" & str & """" & ",FIND(" & """-""" & "," & """" & _
str & """" & ",1)+1)+1)) = TRUE,"""", MID(" & """" & str & """" & ",(FIND(" & """-""" & "," & """" & _
str & """" & " ,FIND(" & """-""" & "," & """" & str & """" & ",1)+1))+1,1))"
Thanks&Regards
Ramesh
Bookmarks