Inserting space in between formulas
=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?
|