You cannot save just one sheet.

Copy the cells to a new sheet in a new workbook.

Paste Special as Values.

Save that workbook as *.CSV


Gord Dibben MS Excel MVP

On Wed, 13 Aug 2008 15:52:00 -0700, Pat
wrote:

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.