Here’s a handy excel formula to remember:
=CONCATENATE(CHAR(39),A2, " ", B2, CHAR(39), CHAR(44))
For quickly generating a list of queryable list of names:
Select * from dbo.Person where Name in ( 'Bill Gates', 'Steve Jobs', 'Larry Ellison', 'Steve Case', 'Jon Carmack', 'Elon Musk', 'Sergey Brin' )
This can be handy if you get spreadsheets from people and want to quickly filter results in the database. I did this today for someone who wanted a list of user names for about 40 people, far too many to spend half an hour typing these in!