Getting Rid of ALL CAPS and extra words (Jr., esq.) in names

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
1.I have put in names of companies sometimes in all caps, and sometimes in title case.  Is there an easy way to get them to all go into title case?

2.In some cases, names of companies are listed as "yadda yadda Inc." or "yadda yadda Corp." I want to have a way to create a version of that name where the Inc./Corp. etc are trimmed off.  How can I do that, and add additional words such as Corporation or "LLC" that should be cut off?  This would be for mail merge purposes.
Photo of Dan

Dan

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
You can accomplish this using the technique in the following thread:
What is the "Clear the Swamp" Technique?
https://quickbase-community.intuit.com/questions/1465790
If you need assistance implementing this feel free to contact me off-world using the information in my profile:
https://quickbase-community.intuit.com/users/513/