MS Excel: Enclose text in double quotes

Assuming that the target column with the text values is A:

1) Create a new column with the following expression: = """" &A1 & """" at the first cell. Drag\Double click to fill the whole column.

2) Copy the values from this new column, and paste them Paste Special --> Values into a third column. Drag\Double click to fill the whole column.

3) You can now delete the original column A and replace it with the column in step (2)

Missing Power View button in Excel 2013

Excel 2013 --> File --> Options

Excel 2013: Removing a defined named range\data table

For normally defined name:
1) Formulas menu.
2) Name Manager.
3) Select the range and delete.


In my case that was a result of a query which generated the named data table:
1) Select the range from the drop down list beside the formula bar.
2) Right click on any cell within that range, and select:
Table --> Convert to Range

The reason I wanted to get rid of that named table in the first place was that filtering and sorting the data inside it was separated from the main sheet.

Microsoft Access: Error copying data to Sharepoint

Error Reproduction:
1) Open Excel file in Access
2) EXTERNAL DATA --> More --> SharePoint List


Error message:
There was an error copying data to a SharePoint list.Duplicate output destination 'Title'.

Workaround:
In my case that was a column with the title "title", just by removing it from the source Excel sheet, the export completed successfully, and even with the column title in the destination!

Another recommendation I read somewhere was to rename the Excel sheet filename to eliminate any special characters, which wasn't my issue.