ExcelBanter - Concatenate

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Concatenate (https://www.excelbanter.com/excel-worksheet-functions/110952-concatenate.html)

Nadeem

Concatenate

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?

Max

Concatenate

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nadeem" wrote:
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?

Nadeem

Concatenate

Thank you, Max. It worked perfectly!

"Max" wrote:

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nadeem" wrote:
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?

Max

Concatenate

You're welcome, Nadeem !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nadeem" wrote:
Thank you, Max. It worked perfectly!

All times are GMT +1. The time now is 07:40 PM.