Exporting to CSV

hey all,

I have a spreadsheet with data I want to enter into a database and there are some formulas to combine fields that I don't want in the exported CSV file.

e.g. A1 contains text "photos/" (without quotes) B1 contains "john_smith.jpg" and C1 contains "=A1 & B1"

when i export it, it shows A1, B1 & C1 but I only need the data from C1 that should show "photos/john_smith.jpg"

is there a way that i can export only the data from C1 or capture it somehow? there are over 800 records that this needs to be applied to.

thanks if you can help

Hi,
one way would be to copy - Paste special - Values col C in another workbook and then save as CSV.

thanks arthurbr, didn't realise about that, all sorted just have to copy it back to the original sheet