Thanks, your second suggestion worked for me with a slight adjustment
changing the 3 to a 2. Thanks again.
"JulieD" wrote:
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