View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

if your data is consistent with the example then you can use
=MID(A1,13,2)
or alternatively try
=MID(A1,FIND("l",A1,3)+1,2)
(with your data in A1)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"D richardson" wrote in message
...

I have a cell that contains l1931-06-05l73lyrs
I want to be able to pull off just the 73, is this possible