Well, it looks like your 'chkstring' function is doubling up the quotes properly, that should work for the 'location' and 'description' fields. If you weren't doubling them you would get a SQL ...

This post shows how to use the TRUNC function in Excel. Use it to remove or truncate decimals, time from date-time format, etc. It is the opposite of Round.