
Anonymous
Not applicable
2018-11-21
09:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Get only the first character in uppercase
I have a list of name in upper cases and i would like to put them on a table in a sheet but with only the first letter in upper case.
I tried with Lower but couldn't find a way to put only the first char in upper case
4,180 Views
1 Solution
Accepted Solutions

Partner - Creator II
2018-11-21
09:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 Replies

Partner - Creator II
2018-11-21
09:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please try =Capitalize(<Fieldname>)
2018-11-21
09:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can even try this?
upper(left(Fieldname,1))&mid(Fieldname,2,len(Fieldname)-1)
upper(left(Fieldname,1))&mid(Fieldname,2,len(Fieldname)-1)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
