How to "convert" part of a value in date?

[agatha1939]

I want to "convert" one character (part of one value) from one column in date (month) in another column... like, when I have RA08001 (or RA08002, RA08045, RA08126, etc) in column A, I need "Jan" in column B. When I have RB08016 (or other sequencial number strating with RB), I need "Feb" in column B... is that possible?

Thanks!

 

[MrKowz]

is this assuming that RA means january, RB means Feb, RC means march, etc?

 

[agatha1939]

Yes, RA=january, RB=february and so on...

 

[DonkeyOte]

you could create a hard wired lookup but assuming A = Jan and L = Dec then you could use something like (in B1)

=TEXT(DATE(2000,COLUMN(INDIRECT(MID(A1,2,1)&"1")),1),"mmm")

 

[MrKowz]

Lasw10 has a good solution there.

If you are needing only jan, feb, mar, etc... what I would do is make a seperate sheet where you have A through L in column A, and Jan-Dec in column B.

Then put the following formula in B2, assuming your data starts there.

=vlookup(mid(a1,2,1),sheet2!$A$1:$B$12,2,FALSE)

copy it down!

 

[agatha1939]

Both ways worked, THANKS!!!!