Read the 2nd, 3rd, and 4th characters of: "Format>Cells>Number>Custom" Set at " MAR "0

[AndyL446]

Cell J4 has "Format>Cells>Number>Custom" Set at " MAR "0
When I enter the number 2 into Cell J4 it dutifully reads (minus the exclamation marks): " MAR 2"
I want to 'read' the 2nd, 3rd, and 4th characters of J4 yielding (minus the exclamation marks): "MAR"
Why?
Using an If Statement in Cell S45 I want to read the 2nd, 3rd, and 4th characters of J4 (3-letter abbreviation for month),
then having read the 3-letter abbreviation place the month full name in Cell S45.
=If(2nd, 3rd, and 4th characters of J4 = "JAN", "JANUARY",If(2nd, 3rd, and 4th characters of J4 = "FEB", "FEBRUARY", and so on thru the 12 months,"???")))))))))))

I'm guessing in Excel there is neater way to accomplish same objective. The method above, if possible, and although maybe more cumbersome; works for me... given 'reading' the 2nd, 3rd, and 4th characters of J4 is possible.

I always end my If statements acting on text with: ,"???") This alerts me if I've made a typo in J4, I get "alerted" when S45 displays (minus the exclamation marks): "???"

Thanks,

_Andy L

[BMV]

Worksheet function can't read format and display text and you have to use UDF or macro function. But the best way to keep date 03/01/YYYY in the cell and use МММ D формат.
in the name
GetTextcell :

Please Login or Register  to view this content.

Or UDF

Please Login or Register  to view this content.

Macro must be enabled!

[AndyL446]

SOLVED! Not the prettiest way, but SOLVED.
Where there was one (1) column and Cell J4 Custom Number Format was " MAR "0
I added another column and split:
One column contains only 3-letter month abbreviation: MAR
and the added column contains only the date number: 2