Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

How to Normalize Country Names to Title Case in Excel | Clay

How to Normalize Country Names to Title Case in Excel

·Feb 20, 2025 06:49 PM·

I've been trying to create a formulae to tidy up some columns where the countries are in CAPITALS and i want to normalise them so that only the first letter of each country name is capitalised e.g. Germany, United Kingdom etc .... can you help me as so far its not been working!

5 comments

· Sorted by Oldest

Channeled
APP
·
·
You can use Clay's built-in Normalize Case feature to transform your country names into proper case format. Here's how: 1. Go to the enrichment panel and find the "Tools" section 2. Select "Normalize Company Name" action 3. Choose your country names column as the input 4. Enable the "Normalize Case" option - this will automatically transform text from all uppercase to Title Case 5. Run the enrichment on your selected rows This will convert country names like "GERMANY" to "Germany" and "UNITED KINGDOM" to "United Kingdom".
Sources: Clay formatters overview | Documentation | Clay University Normalize Company Name with Clay Formatters
Channeled
APP
·
·
Did that answer your question?
Mike B.
·
·
thanks
Channeled
APP
·
·
I'm delighted to hear that! I'm here if you need any further assistance.
Channeled
APP
·
·
Hi Mike B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: