Concatenate

N

Nadeem

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?
 
M

Max

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)
 
N

Nadeem

Thank you, Max. It worked perfectly!

Max said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate cells with line breaks in them 4
Two columns followed by single page-width column on same page 0
Constructing Range Name calls with Concatenate 4
Concatenation 3
Converting URLs in comments to Markdown-formatted links 2
Wrapping and Anchors 0
Select Text to End of Footnote 9
Delimiters in Text to Columns 0

Top