# Text-Transform hack for all caps to proper case **URL:** \ **Category:** Email Marketing Tool\ **Created:** [February 7, 2019, 7:01pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856 "2019-02-07T19:01:13Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Yowza](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/yowza/32/9373_2.png) [@Yowza](https://community.hubspot.com/u/Yowza)\ **Post date:** [February 7, 2019, 7:01pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/1 "2019-02-07T19:01:13Z")
Personalzing an auto-response email to form submissions and trying to correct for improper casing on submitter data. Using text-transform options I can obviously switch to all CAPS, all lower, or force a Capital first letter. Using Capitalize I can ensure that anyone who submitted in all lower is corrected in my auto-response, but does anyone know a trick to convert all caps to First Caps and rest lower? ---
**Author:** ![Mike\_Eastwood](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mike_eastwood/32/70075_2.png) [@Mike\_Eastwood](https://community.hubspot.com/u/Mike_Eastwood)\ **Post date:** [February 7, 2019, 7:48pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/2 "2019-02-07T19:48:53Z")
Hi @Yowza You should contact [@Samantha\_Alford](https://community.hubspot.com/t5/user/viewprofilepage/user-id/205) - she got so annoyed by upper case names she created an app to fix them. Mike ---
**Author:** ![Sam\_Alford](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sam_alford/32/31184_2.png) [@Sam\_Alford](https://community.hubspot.com/u/Sam_Alford)\ **Post date:** [February 8, 2019, 1:23am UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/3 "2019-02-08T01:23:44Z")
Thanks for the shout out [@Mike\_Eastwood](https://community.hubspot.com/t5/user/viewprofilepage/user-id/9259) 🙂 @Yowza, I’ve recently developed a custom workflow action that corrects the case and takes into consideration the following examples eg. samantha alford or SAMANTHA ALFORD = Samantha Alford, mcdonald or MCDONALD = McDonald, aj simpson = AJ Simpson, van der stein = van der Stein etc. There are a heap of other scenarios as well that I’ve built into the tool. All you have to do is create a workflow that has an enrolment trigger of when your form(s) are completed and then add the custom workflow action and it corrects it for you. If the person has already put the correct case then it leaves it as is. Best of all it’s FREE. You can check it out here: [https://inboundaddons.com/change-name-case](https://inboundaddons.com/change-name-case). It is currently best suited for when forms are submitted but I’m adding on the ability to go back through your whole database and fix up ones that are already submitted incorrectly. Hope that helps. Cheers, Sam ---
**Author:** ![ds\_cv](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ds_cv/32/84335_2.png) [@ds\_cv](https://community.hubspot.com/u/ds_cv)\ **Post date:** [April 1, 2019, 10:50pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/4 "2019-04-01T22:50:14Z")
Thanks for making this. Been searching for a solution for ages! ---
**Author:** ![Sam\_Alford](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sam_alford/32/31184_2.png) [@Sam\_Alford](https://community.hubspot.com/u/Sam_Alford)\ **Post date:** [April 3, 2019, 11:14pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/5 "2019-04-03T23:14:49Z")
Hey [@ds\_cv](https://community.hubspot.com/t5/user/viewprofilepage/user-id/69274) , you’re very welcome! 🙂 I’ll post here when I have the bulk update feature available also. Cheers, Sam ---
**Author:** ![KeeganSmith87](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/keegansmith87/32/76463_2.png) [@KeeganSmith87](https://community.hubspot.com/u/KeeganSmith87)\ **Post date:** [September 17, 2019, 1:34pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/6 "2019-09-17T13:34:00Z")
Anxiously awaiting the ability to run customers through this on a bulk process!!! ---
**Author:** ![JenP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jenp/32/62359_2.png) [@JenP](https://community.hubspot.com/u/JenP)\ **Post date:** [September 2, 2019, 3:46am UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/7 "2019-09-02T03:46:28Z")
Hi Sam, Have you or are you planning on creating one for the City and State/Region fields? I want to make those fields both CAPS only and can’t find a way to do that. If you are that would be great. I’d also love one that put the spaces in phone numbers as well. Cheers Jenny ---
**Author:** ![tg52](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tg52/32/35608_2.png) [@tg52](https://community.hubspot.com/u/tg52)\ **Post date:** [October 11, 2019, 4:01pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/8 "2019-10-11T16:01:57Z")
This is really great - thanks Sam! Should definitely be a built in feature. Best, Theo ---
**Author:** ![Sam\_Alford](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sam_alford/32/31184_2.png) [@Sam\_Alford](https://community.hubspot.com/u/Sam_Alford)\ **Post date:** [October 13, 2019, 3:38am UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/9 "2019-10-13T03:38:37Z")
Thanks Theo (@tg52), I’m glad you like it! Cheers, Sam ---
**Author:** ![jasonashaw](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jasonashaw/32/34870_2.png) [@jasonashaw](https://community.hubspot.com/u/jasonashaw)\ **Post date:** [October 17, 2019, 5:02pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/10 "2019-10-17T17:02:50Z")
Hi Sam, I added this to our Hubspot and tried it. It seems to work on some records and not others. I can see that the contact went through the workflow and was marked as success, but the records remains all lower. Is there something we aren’t doing right? Thanks! Jason ---
**Author:** ![djkelly](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/djkelly/32/72490_2.png) [@djkelly](https://community.hubspot.com/u/djkelly)\ **Post date:** [February 21, 2020, 8:24pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/11 "2020-02-21T20:24:57Z")
Sam - we’ve been going crazy fixing names, I just added this, it works great! We’ve been sending personalized HubSpot email along with direct mail letters and postcards that use personalization tags via Postalytics in workflows, this will save us LOTS of time & worry. Thanks for doing this - I’m planning to blog on it! ---
**Author:** ![KeyWestScott](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/keywestscott/32/70903_2.png) [@KeyWestScott](https://community.hubspot.com/u/KeyWestScott)\ **Post date:** [March 17, 2020, 9:42pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/12 "2020-03-17T21:42:39Z")
[@Sam\_Alford](https://community.hubspot.com/t5/user/viewprofilepage/user-id/50781) Thank you sooooo much. Am definitly looking forward to your “update” for checking existing contacts… This would be fantastic. Scott ---
**Author:** ![bradytraeder](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bradytraeder/32/64675_2.png) [@bradytraeder](https://community.hubspot.com/u/bradytraeder)\ **Post date:** [April 13, 2020, 10:40pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/13 "2020-04-13T22:40:06Z")
Sam did you complete the ability to add this to exsiting database items? ---
**Author:** ![lgil](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lgil/32/73391_2.png) [@lgil](https://community.hubspot.com/u/lgil)\ **Post date:** [August 9, 2020, 9:11pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/14 "2020-08-09T21:11:53Z")
[@Sam\_Alford](https://community.hubspot.com/t5/user/viewprofilepage/user-id/50781), I’m trying to access your custom workflow action through the link you shared but I keep receiving an errror message. ![30102iA0FC0E53879C13E7.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/a/fac25f67a754f7e7f0c7c71867d3fc5fce380fcd.png) Is there a way I could get that info? ---
**Author:** ![jillkurpershoek](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jillkurpershoek/32/7115_2.png) [@jillkurpershoek](https://community.hubspot.com/u/jillkurpershoek)\ **Post date:** [September 18, 2020, 9:53pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/15 "2020-09-18T21:53:01Z")
Hi Sam, I downloaded the workflow action and it ended up making everything lowercase. Is there anyway to reconfigure this? I’m not quite sure where I went wrong, but we’d really like to use this tool. Thanks, Jill ---
**Author:** ![elanashama](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/elanashama/32/48165_2.png) [@elanashama](https://community.hubspot.com/u/elanashama)\ **Post date:** [June 23, 2022, 3:33pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/16 "2022-06-23T15:33:28Z")
this addon is great, thanks! ---
**Author:** ![Sam\_Alford](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sam_alford/32/31184_2.png) [@Sam\_Alford](https://community.hubspot.com/u/Sam_Alford)\ **Post date:** [June 24, 2022, 6:38am UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/17 "2022-06-24T06:38:53Z")
Thanks Elana, I’m so glad you like it. All the best, Sam ---
**Author:** ![PatrickH429](https://avatars.discourse-cdn.com/v4/letter/p/a6a055/32.png) [@PatrickH429](https://community.hubspot.com/u/PatrickH429)\ **Post date:** [August 4, 2022, 1:28pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/18 "2022-08-04T13:28:16Z")
this add-on works, thanks! ---
**Author:** ![Paul320](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/paul320/32/58551_2.png) [@Paul320](https://community.hubspot.com/u/Paul320)\ **Post date:** [March 17, 2020, 9:32pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/19 "2020-03-17T21:32:03Z")
This is a feature/function that HubSpot ought to make available in Workflows. Someone took the time to add it to the [HubSpot Product Ideas](https://community.hubspot.com/t5/HubSpot-Ideas/Contacts-Capitalization-of-Contact-Fields/idc-p/326328#M53106) website. Please use the link to the left and upvote it. It needs 100 upvotes to get noticed. Tell all your HubSpot users / clients! ---
**Author:** ![elizsmith](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/elizsmith/32/35926_2.png) [@elizsmith](https://community.hubspot.com/u/elizsmith)\ **Post date:** [August 25, 2021, 12:34pm UTC](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856/20 "2021-08-25T12:34:46Z")
Is there any solution available to transform all lowercase names to sentence case? The app created by [@Sam\_Alford](https://community.hubspot.com/t5/user/viewprofilepage/user-id/50781) works for upper to sentence case, but we also have form submissions coming in where the names are lower. [Next page](https://community.hubspot.com/t/text-transform-hack-for-all-caps-to-proper-case/12856.md?page=2)