adding digits to front/end of fax numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i add "1" before each fax number and ",,7741" at the end of each one?
we have to dial one to dial long distance and we have a code to use the long
distance in our office. please help quickly. Thanks
 
Hi!

Fax number in A1:

=1&A1&",,7741"

If you want a space after the 1:

=1&" "&a1&",,7741"

Biff
 
In a blank column try
=1&A1&7741
Copy down. Copy whole new column. Paste special Values over old numbers.
Is that what you're trying to do?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows Fax and Scan: Adding 'pauses' to a dialled number 5
Why do I have a +1 in front of every telephone and fax number? 1
dialer not following rules for 800, 877, 866..number 1
Adding an company long distance access code at the end of my fax 1
Cannot get MS Fax to use a calling card 9
Configuration puzzle: long-distance access code ignored 7
Number to Time 1
Country Code +1 inserted in before phone number 5

Back
Top