insert number in column

  • Thread starter Thread starter afdmello
  • Start date Start date
A

afdmello

I have a column with threedigits for telephone extensions. I want to insert
a digit before the three throughout the column as the extension has been
increased to 4 digits. Any easy way.../

Thanks.

AFD
 
Type 4000 in an unused cell, then Copy > it and highlight your list of 3
digit numbers and Right-click > PasteSpecial > Add.......this will place a
"4" on the left end of each string. Instead of 4000, use 3000 or whatever
the new digit is to be.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top