How to add space after text

[jacksonjw81]

Column A, has a bunch of names, I need column B to take the names from column A and add a space with OR at the end.

Example

Michael Jackson need it to be Michael Jackson or
Rhonda Rousey need it t be Rhona Rousey or


Better yet the end result would take all the names in column A and put them in a cell where it would be Michael Jackson or Rhonda Rousey or all within the same cell.

Thank You


EDIT: The names need to be within " ".

 

[Kamolga]

if name is in a1

=A1&" or"

 

[jacksonjw81]

if name is in a1

=A1&" or"

Thank you, how would I add " " before the first name and after the last name?

"Michael Jackson" or "Rhonda Rousey" or

Thanks again

 

[Kamolga]

You are welcome

how would I add " " before the first name and after the last name?

=""""&A1&""""

will put "" around name in a1 -> "Michael Jackson"

=""""&A1&""""[COLOR=#333333][I]&" or"[/I][/COLOR]

will get you "Michael Jackson" or