Thread: Save As
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Pat is offline
external usenet poster
 
Posts: 210
Default Save As

I have a spreadsheet with 3 sheets. The first sheet contains original data.
The third sheets contains lookup data. The second sheet has formulas in
several rows that CONCATENATE data from several cells in sheet one into a
single cell in sheet two or have LOOKUP formulas that convert data from sheet
one based on a look-up in sheet three.

Question: Is it possible to export sheet two as a csv file without formulas
so only the replaced text strings show? If so, how?

Thanks, your help has been great with my previous two issues on this project.