I have values in Excel spreadsheets that I would like to format for creating INSERT statements to be run in SQL.
Based on whether a column heading value is C for Character or N for numeric, the value would either apostrophe before and after the value or no apostrophes if it is numeric...