View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Append value to cell or cells

Insert a "helper" column and enter this formula:
="(123) 456-"&A1
....where A1 holds the extension. Copy that formula, and paste for the
rest of the extensions.