Thanks, that worked great! Now I want to delete the column that references
that formula, but I get "ref" in the column that I put the formula. Is there
a way to delete that column but still keep my formula intact?

"Boo" wrote:

=A1 & " " & B1

or

=A1 & " - " & B1

Where,

A1 = First part of text (or numbers)
B1 = Second part of text (or numbers)

Substitute A1 / B1 with the relevant cells in your spreadsheet

"Mary" wrote:

I put in a formula to combine a string of words with numbers and would like a
space or dash to go in between. How do I do this?