Call us: 877-740-0009
Creating a Dialing List (click on underscores for visuals)
- From a data base spread sheet such as Excel select only
the column with phone numbers, highlight it and copy and paste it on to a
blank workbook in the
A column by dropping
your curser there and hitting paste.
- If there are any ( ) . - or spaces you must remove them. To do so is easy!
- Open the excel file you want to use the numbers from.
- Highlight all the phone numbers.
- Go to Edit/Find
( In excel 2007 find is all the way to the right at the top)
- At "find what," put the character you need to remove
- Click "find all"
- Then hit replace and leave the replace with blank and hit "replace all"
- Continue to do that for the other) and any dashed or spaces do this one symbol at a time.
To remove a space at the find what hit the space bar once.
- You can then go back to the original page where you copied the numbers from and get the names
list and copy it then paste them in the second
column next to there respective number by dropping your curser in column B.
- Go to "save as" and select a name and file type csv
- Save to desk top for easy access when placing a call
- Sample of what your list should look like. You can only have the numbers in column A and the
names in column B and nothing else.
3305551234 John Doe
8025552233 Jane Doe