Here’s a handy excel formula to remember:

=CONCATENATE(CHAR(39),A2, " ", B2, CHAR(39), CHAR(44))

list of names excel

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!