How to Download Your Healthcare Fax Numbers
Update release    
August 20, 2019    
Compare All Healthcare Provider Database Products

CarePrecise Medical Marketing Tools

How to change the fax number format

For easy reading, we format the fax numbers with hyphens (-), for instance: 915-555-6254. If you are planning to send bulk faxes, you may want to remove the hyphen. That's easy in Excel, as is appending a "1" at the front of the number if your faxing software requires it.

To remove hyphens:

  1. In Excel, add a new column.
  2. Create a formula in the top cell of the new column: =SUBSTITUTE(J2,"-","") where J2 is the top fax number column cell.
  3. Copy the new cell down to the last row.
  4. Refer to your Excel documentation, or search Google, for additional information and formatting tricks.

To append a "1" at the front of the fax number:

  1. In Excel, add a new column.
  2. Create a formula in the top row of the new column: ="1" & J2 where J2 is the top fax number column cell.
  3. Copy the new cell down to the last row.
  4. To both append a "1" and remove hyphens, the formula is: ="1" & SUBSTITUTE(J2,"-","")
  5. Refer to your Excel documentation, or search Google, for additional information and formatting tricks.

See a menu of all of our fax number databases.

 

 

 

 

Policies and Terms of Use