Index left match or lookup???

[Carrie]

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

 

[Niek Otten]

Hi Carrie,

If you mean the 5th and 6th character:

=MID(A1,5,2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Gary''s Student]

=MID(A1,3,2) will return 08
=MID(A1,5,2) will return D1