Adding a space to a string

  • Thread starter Thread starter lennymos123
  • Start date Start date
L

lennymos123

Hi i am trying to add a space i.e Column A1 " hello " Column B1 "mom"
with column C1 reading "hello mom" at the moment it reads "hellomom" i
know it maybe a simple question but new to this

Paul
 
Considering that the A1 in the example already had a trailing
space. Perhaps =TRIM(A1) & " " & TRIM(B1)
would be safer. Capitalization is another problem, at least
in English..
 
Back
Top