adding 1 before phone number

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am looking to add a 1 before all of my long distance
phone numbers...but I don't want to go through every cell
and add 1...is there an easier way??
 
Add a column somewhere alongside and use the formula
=concatenate("1",A1) and replace A1 with the cell containing the
number.

Alternatively, ASAP Utilities has a function to add leading text
(and a whole raft of other useful functions).

Cheers,
Richard Carter

========================
richard at rjcarter dot net
 
You can use a macro Chris

Select the cells and run this

Sub test()
For Each cell In Selection
cell.Value = "1" & cell.Value
Next
End Sub
 
Back
Top