Bulk Apostrophes and Commas for SQL Queries

Hi all

So once again Excel has come to my rescue, however this time I had a list of building IDs that were alphanumreic so they needed apostrophes around them and a comma at the end.

E.g. 'ABC123',

So here's the Excel trick...

Right click the highlighted cells --> Under the 'Number' tab choose 'Custom' --> Then where it says 'General' type '@\',

HEY PRESTO!