Clever Geek Handbook

Name of the month in the regional language and preferably in English

I use this formula to get the first three letters of the month with the first letter in the capital (i.e. Jan, Feb, Mar, Apr, ...):

=UPPER(LEFT(TEXT(B1;"mmm");1)) & MID(TEXT(B1;"mmm");2;2)

But it gives the result to me in my own language and I want it in English .

My Excel and all Office are in English , I only have French locales (which I prefer to keep, or I really don't want to change them every time I use this feature).

Is there a way to change the output language of a function TEXT

?

+3


source to share


2 answers


Based on @Amit excellent answer, I would say =TEXT(B1;"[$-409]mmm")

.

Since the English month name is already capitalized on the first letter.

If that's not enough, there is a function Proper

that will only use the first letter of the word.



Format

mmm is already 3 char long in english. No need for LEFT (). Correct () uppercase first char.
Note that using 040C for French, for example, it may return longer strings! For example: "Juil". for July.

+1


source


You can force to TEXT

use a specific locale (in English in your case ...).
Try the following:=UPPER(LEFT(TEXT(B1;"[$-409]mmm");1)) & MID(TEXT(B1;"[$-409]mmm");2;2)



+5


source






More articles:


All Articles