cancel
Showing results for 
Search instead for 
Did you mean: 

Use Upper Function in Text

CemileDemirci
Level 3
Is it possible to use the UPPER function for only the first letter from a Data Item ? How can i do this? I use this but all the same letter wil be Uppercase Replace([Data1]; Left([Data1]; 1); Upper(Left([Data1]; 1)))   if the word is test it will be formatted to TesT
2 REPLIES 2

John__Carter
Staff
Staff
Upper(Left([Data1], 1))&Lower(Mid([Data1], 2, Len([Data1])))

CemileDemirci
Level 3
Thank you it works