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.
|