Make certain that the fax numbers are in the
first column. Please note that the number should
include the country code, area code, and the
number. The number should be in one long number
for example "18885553000". If the fax numbers
are not in the first column right click on the
letter above the column with the fax numbers,
and now click on "Cut"
right click on the letter "A"
first column and click on "Insert Cut Cells"
this will move the fax numbers to the first
column of the spread sheet.
To remove punctuation marks from your fax list.
Your fax list should now be in column "A". Click
on "A" ,
this will highlight the entire column "A". Now
holding down the "Ctrl" key on your keyboard
press the "H" key this will open the Replace
Click on the "Find what" field and type "-" in
and then click on the "Replace All"
button . Repeat this process to clean all the
punctuation marks and spaces from your fax
numbers. Now remove any header rows in your fax
list by clicking on the number besides the fax
header row and then click on edit and delete,
this will remove the header row and you show
have a list that may match the one below.