# Add proper case option to data format **URL:** \ **Category:** Data Hub\ **Tags:** professional\ **Created:** [December 20, 2021, 10:44pm UTC](https://community.hubspot.com/t/add-proper-case-option-to-data-format/48834 "2021-12-20T22:44:30Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![JenWallace](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jenwallace/32/31184_2.png) [@JenWallace](https://community.hubspot.com/u/JenWallace)\ **Post date:** [December 20, 2021, 10:44pm UTC](https://community.hubspot.com/t/add-proper-case-option-to-data-format/48834/1 "2021-12-20T22:44:30Z")
We have just started with Operations Hub and I’m setting up some automation that cleans up our data. I have alot of names that are in All Caps. Just using the option to “capitalize” under the automation format data doesn’t work. The only way I found to solve this was to first do an activity to change the name to all lower case. Then I have to add a second command to do the capitalization. While it worked in the end, it seems a whole lot easier to just have “proper case” be used. Could solve other issues as well for names like De Joes. If there is an easier way to do this please advise ---
**Author:** ![FransLeys](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fransleys/32/28441_2.png) [@FransLeys](https://community.hubspot.com/u/FransLeys)\ **Post date:** [January 3, 2022, 1:28pm UTC](https://community.hubspot.com/t/add-proper-case-option-to-data-format/48834/2 "2022-01-03T13:28:35Z")
Hi @JenWallace Sounds like this can be covered by the single action called ‘Title case’ ![FransLeys_3-1641216506768.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/a/a679bf9aebc351a2343b0e5d9b17aee4d8743722.png) ---
**Author:** ![GBeckwith](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gbeckwith/32/102498_2.png) [@GBeckwith](https://community.hubspot.com/u/GBeckwith)\ **Post date:** [March 10, 2022, 2:43pm UTC](https://community.hubspot.com/t/add-proper-case-option-to-data-format/48834/3 "2022-03-10T14:43:01Z")
Where do I find these Formatting Rules? I am struggling to find where you are in this screen? ---
**Author:** ![FransLeys](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fransleys/32/28441_2.png) [@FransLeys](https://community.hubspot.com/u/FransLeys)\ **Post date:** [March 10, 2022, 2:53pm UTC](https://community.hubspot.com/t/add-proper-case-option-to-data-format/48834/4 "2022-03-10T14:53:28Z")
You find more information here: > **[Format your data with workflows](https://knowledge.hubspot.com/workflows/format-your-data-with-workflows)** > > Learn how to use workflows to automatically format your CRM data. ---
**Author:** ![TBillett1](https://avatars.discourse-cdn.com/v4/letter/t/9de0a6/32.png) [@TBillett1](https://community.hubspot.com/u/TBillett1)\ **Post date:** [November 20, 2024, 9:46pm UTC](https://community.hubspot.com/t/add-proper-case-option-to-data-format/48834/5 "2024-11-20T21:46:39Z")
This does not seem to work with hyphenated names, would that need to be removed for the title case to make both names capitatlized? ---
**Author:** ![DianaGomez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dianagomez/32/48035_2.png) [@DianaGomez](https://community.hubspot.com/u/DianaGomez)\ **Post date:** [December 5, 2024, 10:27am UTC](https://community.hubspot.com/t/add-proper-case-option-to-data-format/48834/6 "2024-12-05T10:27:30Z")
Hi @TBillett1, Thanks for reaching out to the Community! Could you please clarify your objective so I can investigate and suggest the necessary action to achieve it? Are you asking for everything to be in uppercase, or what is your specific intention? If you could provide an example or a screenshot of how you’d like it to appear, I can look into whether it’s possible. Thank you! Diana