View Single Post
  #2   Report Post  
jiwolf
 
Posts: n/a
Default

yes. Assuming your list is is column A, with the first entry in cell A1, and you wish to add area code "01902"

enter the following into cell B1, ="01902"& A1 then copy and paste down.




"PPuser" wrote in message ...
I have multiple lists containing phone numbers that don't include an area
code. Is there a way to automatically add the same area code to the list?
Thanks