Add Tel # area code to column list

  • Thread starter Thread starter harryhill
  • Start date Start date
H

harryhill

I need to have have a column formatted as Custom for the tel number
(435) 041-0987. I know how to do that.

Problem-the workbook was made by a parochial person and put them all i
as: 041-0987. The (435) needs to be added. I mean a couple hundred.

How do I Find/Replace-or ADD the (435) without killing the numbers
 
Use a help column, assume they start in A1, if B1 is not empty, click the
header of column B to select it,
do insert>columns

Now in B1 use this formula

="(435) "&A1

press enter
reselect B1, move cursor to the lower
right corner of B1 and when it changes
from a fat cross to a thin double click the mouse
to copy down the formula (or grab the lower
right corner and drag)

Select column B and copy it, do edit>paste special as values in place
Make sure everything went well and delete column A
 
An easy way is to auto fill (435) in the column next to your numbers.
Say column A


A b

(435) 555 - 5555 =A1&" "&b1


(435) 555-5555 (435) 555-5555


Gre
 
Hi Harry
Since your phone numbers are actual numbers all you need to do is add 4350000000 to each number

1) type 4350000000 in a blank cel
2) copy that cel
3) select the range of phone number
4) Edit>Paste_Special>Ad

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- harryhill > wrote: ----

I need to have have a column formatted as Custom for the tel number
(435) 041-0987. I know how to do that

Problem-the workbook was made by a parochial person and put them all i
as: 041-0987. The (435) needs to be added. I mean a couple hundred.

How do I Find/Replace-or ADD the (435) without killing the numbers
 
Back
Top