View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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