Jun 23 • General Discussion 💬
📌 Need to clean up company names in Google Sheets?
A client asked me how to normalize messy business names — so I’m sharing the solution here for anyone else dealing with the same headache.
✅ Goal:
Strip off things like “LLC,” “Inc.,” and trailing punctuation, convert “+” to “and,” and clean up extra spaces — optionally normalize capitalization too.
🔧 Google Sheets Formula (Preserve Capitalization):
excel
Copy
Edit
=TRIM(
REGEXREPLACE(
REGEXREPLACE(
REGEXREPLACE(
REGEXREPLACE(B2, ",?\s*\b(LLC|Inc|Incorporated|Corp|Corporation|Ltd)\b\.?", ""),
"\+",
"and"
),
"\s+",
" "
),
"[\.,]$",
""
)
)
Examples
Kane Partners LLC → Kane Partners
BURKE + CO → BURKE and CO
🔠 Normalize Capitalization (Optional):
excel
Copy
Edit
=PROPER(
TRIM(
REGEXREPLACE(
REGEXREPLACE(
REGEXREPLACE(
REGEXREPLACE(B2, ",?\s*\b(LLC|Inc|Incorporated|Corp|Corporation|Ltd)\b\.?", ""),
"\+",
"and"
),
"\s+",
" "
),
"[\.,]$",
""
)
)
)
More Examples:
Dental Medical Careers, Inc. → Dental Medical Careers
Solve IT Strategies, Inc. → Solve IT Strategies
Global Talent Partners + Associates LLC → Global Talent Partners and Associates
Jade & Co. Executive Search LLC → Jade & Co Executive Search
Drop a 💬 if you want to adapt this formula for different cases like removing “|” or trimming website taglines!
7
1 comment
📌 Need to clean up company names in Google Sheets?
skool.com/ai-automation-society
A community built to master no-code AI automations. Join to learn, discuss, and build the systems that will shape the future of work.
Leaderboard (30-day)
1
🔥
+2491
2
🔥
+1126
3
+1050
4
🔥
+871
5
+727
Powered by