Index left match or lookup???
 

Hi - I need to return in cell A2 the 3rd and 4th characters from cell A1. I
know I have done this in past but can not find it now!
e.g.
A
1 0708D1MOQ
2 D1

Thanks for your help :-)
--
Carrie

Index left match or lookup???
 

Hi Carrie,

If you mean the 5th and 6th character:

=MID(A1,5,2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Carrie" wrote in message ...
| Hi - I need to return in cell A2 the 3rd and 4th characters from cell A1. I
| know I have done this in past but can not find it now!
| e.g.
| A
| 1 0708D1MOQ
| 2 D1
|
| Thanks for your help :-)
| --
| Carrie

Index left match or lookup???
 

=MID(A1,3,2) will return 08
=MID(A1,5,2) will return D1
--
Gary''s Student - gsnu200796