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

"Luke" <(E-Mail Removed)> wrote in message
news1C25AF0-7FBC-43CE-855D-(E-Mail Removed)...
> 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

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?

"Luke" wrote:

> 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