# Remove string (e.g. Pty Ltd) from company name using workflow

**URL:** <https://community.hubspot.com/t/remove-string-e-g-pty-ltd-from-company-name-using-workflow/81265>\
**Category:** Data Hub\
**Tags:** data-quality-automation\
**Created:** [May 16, 2023, 8:01am UTC](https://community.hubspot.com/t/remove-string-e-g-pty-ltd-from-company-name-using-workflow/81265 "2023-05-16T08:01:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![BLaRosa](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/blarosa/32/2490_2.png) [@BLaRosa](https://community.hubspot.com/u/BLaRosa)\
**Post date:** [May 16, 2023, 8:01am UTC](https://community.hubspot.com/t/remove-string-e-g-pty-ltd-from-company-name-using-workflow/81265/1 "2023-05-16T08:01:43Z")

</div>

Hi

HubSpot Insights keeps adding/changing company names with teh legal name e.g. Banana Head Pty Ltd. We want to only have the display name e.g. Banana Head.

I’d love to run a workflow that removes specific strings like " Pty Ltd" from a field.

Any ideas how I can do this?

Thanks

Biagio

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [May 16, 2023, 8:15am UTC](https://community.hubspot.com/t/remove-string-e-g-pty-ltd-from-company-name-using-workflow/81265/2 "2023-05-16T08:15:34Z")

</div>

Hi @BLaRosa,

This requires a Operations Hub Professional subscription and can be achieved with the Format data action in a company-based workflow. As a Format, you could either use “Replace characters” to replace “Ltd” with a white space, then use the “Trim leading and trailing whitespace” to remove the empty character.

Without an Operations Hub Professional subscription, this is not possible within HubSpot and without third-party tools.

Best regards!

---

<div class="post-metadata">

**Author:** ![BLaRosa](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/blarosa/32/2490_2.png) [@BLaRosa](https://community.hubspot.com/u/BLaRosa)\
**Post date:** [May 16, 2023, 2:32pm UTC](https://community.hubspot.com/t/remove-string-e-g-pty-ltd-from-company-name-using-workflow/81265/3 "2023-05-16T14:32:28Z")

</div>

Thankyou @karstenkoehler! You are a legend for this. Just needed to be pointed in the right direction and this was exactly what I needed!