How to remove trailing spaces or spaces in between words

Sometimes you might have spaces behind your people or company names and not even know it! At the moment, ProsperWorks does not have a way to search for trailing spaces in the system, but here is a nifty tool to search for them.


Download the free add-on called"Power Tools" from Productivity.

Steps to install:

1. import your data to a Google sheet using the Google sheets add on
https://prosperworks.zendesk.com/hc/en-us/articles/209728123-ProsperWorks-CRM-Custom-Report-Builder

2. Open up the spreadsheet of Google contacts you exported and check for duplicates by downloading an Add-on called "Power Tools" from Productivity. Follow the screenshots for instructions.



3. Click to download "Power Tools"



4. After it has been added, highlight the row you want to find spaces and go to the drop down menu and select "Power Tools" -> "Remove." Follow the Steps to have it remove entries that have leading and trailing spaces and two spaces within one cell.

 

 

 5. After you have cleaned up the spaces, re-import your data and see if that solves the issue of duplicates.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Article is closed for comments.