Phone Number Has extra spaces

+1 vote
144 views
asked Mar 8, 2022 in Fundraising by YAG
When exporting the mail merge screen to excel, the phone numbers have a trailing of extra spaces after the phone number, which is not recognizable as phone number with any software/website, the option of exporting with formatting takes off most spaces, but still keeps one space after the numbers, which leaves us with the same issue mentioned above.

2 Answers

answered Mar 8, 2022 by Admin
selected Mar 8, 2022 by Admin
 
Best answer
Updated.
commented Mar 8, 2022 by YAG
thank you
answered Mar 8, 2022 by Admin
Excel has simple find replace where you can remove all spaces. Please explain which software/website you are trying to use this export to recognize the phone numbers?
commented Mar 8, 2022 by YAG
correct, but that also takes away the space after the brackets which is not the way it should be, and also is just extra steps after each export
commented Mar 8, 2022 by Admin
Search for two spaces by replace. It will not take away the space after the brackets.

Why are you constantly exporting this list?
commented Mar 8, 2022 by YAG
for gabaim

Let's Welcome our New Members

  • astauber of JLS - Mar 27, 2024

  • yaakova of Bnos Menachem - Mar 26, 2024

  • GElefant of YGZM - Mar 21, 2024

  • bmiskin of Yeshiva Gedolah Zichron Moshe - Mar 20, 2024

  • cungar of Kollel Chatzos - Mar 18, 2024

  • sstein of Masores - Mar 18, 2024

  • RochelPultman of Prospect Park Yeshiva - Mar 11, 2024

  • rlefkowits of talmud torah ohel yochanan - Mar 11, 2024

  • Barber739 of Bnos Menachem - Mar 10, 2024

  • Chani Schwarz of Yeshiva K'tana of Waterbury - Mar 07, 2024

...