nbqleebarnes
03-15-2010, 04:11 AM
Hi tpoynton and lucas,
I have a very similar problem although I tried using
=--MID(A1,FIND(":",A1)+7,LEN(A1)-FIND(":",A1)-3)
but I can't get it right for the following data field examples:-
'Item : D0101 - Alfa 67-77 Opel Kadett 66-73(F)
and
'Item : 098650A094 - D3133
and
'Item : D0277/1 - Renault R5 R9 R11 77-86
where I need to extract the Dxxxx or if applicable Dxxxx/1
Would be greatful for the help
Thanks
Lee
I have a very similar problem although I tried using
=--MID(A1,FIND(":",A1)+7,LEN(A1)-FIND(":",A1)-3)
but I can't get it right for the following data field examples:-
'Item : D0101 - Alfa 67-77 Opel Kadett 66-73(F)
and
'Item : 098650A094 - D3133
and
'Item : D0277/1 - Renault R5 R9 R11 77-86
where I need to extract the Dxxxx or if applicable Dxxxx/1
Would be greatful for the help
Thanks
Lee