FIND 2nd character in a string
On Mon, 31 Aug 2009 02:31:01 -0700, 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
=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND(CHAR(1),
SUBSTITUTE(A1,"/",CHAR(1),3))-1),"/",REPT(" ",99)),99))
or, you could use the Data/Text-to-columns wizard with "/" as the delimiter,
and use the third column.
--ron
|