Insert a new column. Enter this formula down all relevant rows. This reads: put Text 1 and Text 2 together. In this case "space space" and whatever is in B1

=CONCATENATE(" ",B1)

You can then...