Adding a space to a string

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

Hi Paul

In C1:
=A1&" "&B1

HTH. best wishes Harald

"lennymos123" <[email protected]> skrev i melding
news:[email protected]...
> 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..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Harald Staff" <[email protected]> wrote in message news:%[email protected]...
> Hi Paul
>
> In C1:
> =A1&" "&B1
>
> HTH. best wishes Harald
>
> "lennymos123" <[email protected]> skrev i melding
> news:[email protected]...
> > 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
> >
>
>