Skip to main content
All CollectionsManaging Groups and Members
"Want to quickly clean up your phone number list in Excel?
"Want to quickly clean up your phone number list in Excel?

Here's a handy trick to remove those pesky '+' symbols and ensure your import goes smoothly."

CallingPost Assistant avatar
Written by CallingPost Assistant
Updated over a week ago
  1. Select your column: Click the column header (e.g., "A", "B", etc.) containing the phone numbers.

  2. Open Find and Replace: Press Ctrl + F to open the "Find and Replace" window.

  3. Replace the '+' symbol:

    • In the "Find what" field, type +.

    • Leave the "Replace with" field empty.

    • Click Replace All.

  4. Repeat for other characters: Follow the same process to remove parentheses ( ), hyphens -, and any extra spaces.

    "Removing these extra characters helps prevent errors when importing your contacts into CallingPost. It ensures all your phone numbers are in a consistent format."

Did this answer your question?