FIND 2nd character in a string
The formula was complicated! but it worked!
Thank you very much.
"Jacob Skaria" wrote:
You can select the column..Data Text to Columns and separate the pieces to
columns....If you are looking for a formula below is one way..
=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("/",A1,FIND("/",A1)+1)+1,LEN(A1)),"/",REPT(CHAR(32),LEN(A1))),LEN(A1)))
If this post helps click Yes
---------------
Jacob Skaria
"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
|