Re calculation field
I am using a calculation field to supposedly help when I export the file as excel for uploading as a .csv file.
I have used the following calculation:
"\"" & FIELD TITLE & "\""
I then save records as Excel. Open up the xls file in Excel to finish off the data everything looks fine e.g. "James" - but when I open in a text editor it is showing as """James""" etc
If I repeat without the calculation field the xls file has James as does the csv opened with a text editor.
What am I doing wrong?
This is doing my head in!