Expression First letter capital

[Fabio_T]

Hi, is there an expression to convert a text getting the first capital letter?

[Suvrutt_Gurjar]

Can you elaborate ?Capitalization of all the words in the text or the first word? 

So, if the text is "first word", do you want result as "First word" or "First Word"

How many words the input text can have?

[Fabio_T]

>>How many words the input text can have?

5-6 words 

[Suvrutt_Gurjar]

Thank you and please respond to this as well.

---

@Suvrutt_Gurjar wrote:

So, if the text is "first word", do you want result as "First word" or "First Word"

---

[Fabio_T]

"First Word"

[Suvrutt_Gurjar · Accepted solution]

Thank you. I think that is not possible in ApSheet currently. 

[OsArcos]

I've also been trying to do what you wanted, and I did it by creating two virtual columns, one that divides the name field and creates a list of words in that field and another that connects the names again but with the first letter of each name in capital letter.

first you create two virtual columns, the first one to split in the name field in a list

and put the following formula SPLIT([column name]).

then create a second column to rejoin the name again and put the following formula:

CONCATENATE(

UPPER(LEFT(INDEX([DIVIDIR NOME],1),1)),LOWER(MID(INDEX([DIVIDIR NOME],1),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],2),1)),LOWER(MID(INDEX([DIVIDIR NOME],2),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],3),1)),LOWER(MID(INDEX([DIVIDIR NOME],3),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],4),1)),LOWER(MID(INDEX([DIVIDIR NOME],4),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],5),1)),LOWER(MID(INDEX([DIVIDIR NOME],5),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],6),1)),LOWER(MID(INDEX([DIVIDIR NOME],6),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],7),1)),LOWER(MID(INDEX([DIVIDIR NOME],7),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],8),1)),LOWER(MID(INDEX([DIVIDIR NOME],8),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],9),1)),LOWER(MID(INDEX([DIVIDIR NOME],9),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],10),1)),LOWER(MID(INDEX([DIVIDIR NOME],10),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],11),1)),LOWER(MID(INDEX([DIVIDIR NOME],11),2,100))," ",

UPPER(LEFT(INDEX([DIVIDIR NOME],12),1)),LOWER(MID(INDEX([DIVIDIR NOME],12),2,100))

)

and so all names have the first capital letter