Try this:
In a cell put your area code * 10000 i.e for area code 123 put 1230000.Copy
this cell, select columns to be changed, paste special==operation=Add and
then OK.
So extension 9876 would be converted to 1239876
Delete cell with area code
HTH
"t2true" wrote:
I have a group of four-digit extensions listed in a spreadsheet and I
need to add an area code and prefix to each. Is there a way to add that
to each cell without editing each cell?
Thanks
--
t2true
------------------------------------------------------------------------
t2true's Profile: http://www.excelforum.com/member.php...fo&userid=3877
View this thread: http://www.excelforum.com/showthread...hreadid=529294