G Guest Sep 21, 2006 #1 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?
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?
G Guest Sep 21, 2006 #2 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)
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)
G Guest Sep 21, 2006 #3 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...
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...
