Use Upper Function in Text
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-07-18 05:36 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-07-18 08:34 PM
Upper(Left([Data1], 1))&Lower(Mid([Data1], 2, Len([Data1])))
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-07-18 01:30 PM
Thank you it works
