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
|