repeat begining number

C

chuck

We are having to enter a number of 10 digit phone numbers
an wonder if there is a way in Excel to repeat the first 3
digits that are the same through out the spreadsheet?
Trying to speed up data entry.
 
N

NH

enter the 7 digits number in cell A1 and On cell B1 enter the formula
=201&a1
replace 201 with the correct area code
 
R

Ron Rosenfeld

We are having to enter a number of 10 digit phone numbers
an wonder if there is a way in Excel to repeat the first 3
digits that are the same through out the spreadsheet?
Trying to speed up data entry.
Click to expand...


Format/Cells/Number/Custom Type: "nnn-"000-0000

Replace nnn with your area code

Enter the actual phone number WITHOUT the hyphen.


--ron
 
C

Chuck

Thanks for your help. I knew it was something like that
but could not find it in the book.

Thanks again
 
C

Chuck

Thanks for your help. I knew it was something like that
but could not find it in the book.

Thanks again
 
Top