| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Index left match or lookup???
=MID(A1,3,2) will return 08
=MID(A1,5,2) will return D1 -- Gary''s Student - gsnu200796 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Index Match?? | Excel Discussion (Misc queries) | |||
| lookup/match/index help | Excel Discussion (Misc queries) | |||
| lookup/index/match - help! | Excel Discussion (Misc queries) | |||
| Lookup/Index/Match HELP! | Excel Discussion (Misc queries) | |||
| MATCH, INDEX, LOOKUP - Help! | Excel Worksheet Functions | |||
Linear Mode
