PC Review


Reply
Thread Tools Rate Thread

adding digits to front/end of fax numbers

 
 
=?Utf-8?B?THVrZQ==?=
Guest
Posts: n/a
 
      27th Apr 2005
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
 
Reply With Quote
 
 
 
 
Biff
Guest
Posts: n/a
 
      27th Apr 2005
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



 
Reply With Quote
 
=?Utf-8?B?d3c=?=
Guest
Posts: n/a
 
      27th Apr 2005
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a zero to the front of numbers Connie Martin Microsoft Excel Worksheet Functions 5 8th May 2009 04:37 PM
need help in adding a ' in front of a column of numbers noreaster Microsoft Excel New Users 4 14th Sep 2008 03:54 PM
adding a leading 0 to only the numbers with 4 digits SwampYankee Microsoft Excel Discussion 4 1st Jun 2006 08:34 PM
Adding a 0 in front of a column of numbers scasawyer Microsoft Excel Programming 1 26th Oct 2005 02:51 PM
Adding a ' to the front of a column of numbers punter Microsoft Excel Misc 4 20th Aug 2004 08:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:55 AM.