View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Boo Boo is offline
external usenet poster
 
Posts: 21
Default 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?