Capitalize only the first letter with LAMBDA in Excel

Question

In order to capitalize only the first letter of a text I used
=UPPER(LEFT(A1,1)) & LOWER(RIGHT(A1,LEN(A1)-1))

With the introduction of LAMBDA function in Excel, how can I create a custom lambda function out of it?

score 3 · Answer 1 · answered Dec 18 '20 at 12:34

Formulas -> Name Manager -> New...

Name: fill in the name which will be used to call the function, e.g. UPFIRST
Refers To: =LAMBDA(x, UPPER(LEFT(x,1)) & LOWER(RIGHT(x,LEN(x)-1)))

OK to save the custom lambda function.
Close to exit the Name Manager.

In the sheet it's called like this:

score 2 · Answer 2 · answered Nov 08 '21 at 07:10

2

I suppose there's always the PROPER function....

answered Nov 08 '21 at 07:10

dbb

2,827
18
16

1

`PROPER` will also capitalize the second word, what is not desired. – ZygD Nov 08 '21 at 09:29

score 1 · Answer 3 · edited Dec 18 '20 at 13:23

1

Nice a first question about LAMBDA() =).

Maybe just:

=LAMBDA(X,REPLACE(LOWER(X),1,1,UPPER(LEFT(X))))(A1)

If you want the "machine" then use =LAMBDA(X,REPLACE(LOWER(X),1,1,UPPER(LEFT(X)))) in your name manager.

edited Dec 18 '20 at 13:23

ZygD

22,092
39
79
102

answered Dec 18 '20 at 13:06

JvdV

70,606
8
39
70

Capitalize only the first letter with LAMBDA in Excel

3 Answers3