How to combine columns horizontally in Excel with the and (&) operator (Array). Combining first and last name in Excel example

An example of how to combine columns horizontally in Excel with the and (&) operator (Array). Combining first and last name in Excel