Concatenate

[Guest]

When I concatenate text from two cells, the texts get joined together. i want
to insert a space between the two text strings. Any ideas?

 

[Guest]

Assuming source data in A1 and B1,
In C1: =A1&" "&B1

Or, perhaps better with a TRIM to remove any possible extraneous white
spaces in the source data, in C1: =TRIM(A1&" "&B1)

 

[Guest]

Thank you, Max. It worked perfectly!

Assuming source data in A1 and B1,
In C1: =A1&" "&B1

Or, perhaps better with a TRIM to remove any possible extraneous white
spaces in the source data, in C1: =TRIM(A1&" "&B1)

 

[Guest]

You're welcome, Nadeem !