Chris Davison
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 1,790
Evening all,
if in A1 I have "Feb" as text, what's the formula to convert this into a value ?
ie 2 (2 being the second month in a year)
or if I have "Sep" then I want 9, etc etc
Embarrasingly, I couldn't figure it out without using a VLOOKUP and now I can't sleep
many thanks
Chris
if in A1 I have "Feb" as text, what's the formula to convert this into a value ?
ie 2 (2 being the second month in a year)
or if I have "Sep" then I want 9, etc etc
Embarrasingly, I couldn't figure it out without using a VLOOKUP and now I can't sleep
many thanks
Chris