FIND 2nd character in a string
Perfect!!!
It worked!! Thank you....
Was wondering how to get the second "/" in that mid formula....
Coz i had used the mid as well as the find formula... just dint know how to
get the 2nd "/"
God Bless!
"Shane Devenshire" wrote:
Hi,
Suppose the string you are looking for 78445945 is always 8 characters, then
=MID(A1,FIND("/",A1,FIND("/",A1)+1)+1,8)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Fuzzy" wrote:
how do i use the FIND function to get the 2nd character?
for eg:
A1 has 005/0101/78445945/2002
the entire column has strings like the above....
i want only those characters after the 2nd "/" and before the 3rd "/"
what formula to use?
in the above result, the answer should be - 78445945
|