I ahve a spreadsheet were the first name and last name are in sperate colums.
I can join combine the two and copy as a value. When I combine them though
there are several extra spaces. Does anyone know what causes this and how to
fix it? here is an example:

John Smith shows as John Smith

Trim function
"Jennie" wrote in message
...
I ahve a spreadsheet were the first name and last name are in sperate
colums.
I can join combine the two and copy as a value. When I combine them though
there are several extra spaces. Does anyone know what causes this and how
to
fix it? here is an example:

John Smith shows as John Smith

=TRIM(A1&" "&B1)


"Jennie" wrote:

I ahve a spreadsheet were the first name and last name are in sperate colums.
I can join combine the two and copy as a value. When I combine them though
there are several extra spaces. Does anyone know what causes this and how to
fix it? here is an example:

John Smith shows as John Smith

How are you joining/combining the two names?

=A1 & B1

=CONCATENATE(A1,A2)

Either method will produce spaces if you have extra spaces in the cell values.

Try =TRIM(A1 & " " & B2) to return John Smith


Gord Dibben MS Excel MVP


On Fri, 8 Jun 2007 14:50:00 -0700, Jennie
wrote:

I ahve a spreadsheet were the first name and last name are in sperate colums.
I can join combine the two and copy as a value. When I combine them though
there are several extra spaces. Does anyone know what causes this and how to
fix it? here is an example:

John Smith shows as John Smith

The trim function does not neet the extra &" " in between. The definition
is: removes all spaces from a text string except for a single space between
words. Of course if you need more than one, then you would use " " but it
looks like the OP was looking for one, I am using 2007 version, don't
remember if other versions were different. So =TRIM(a1&b1)

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
How are you joining/combining the two names?

=A1 & B1

=CONCATENATE(A1,A2)

Either method will produce spaces if you have extra spaces in the cell
values.

Try =TRIM(A1 & " " & B2) to return John Smith


Gord Dibben MS Excel MVP


On Fri, 8 Jun 2007 14:50:00 -0700, Jennie

wrote:

I ahve a spreadsheet were the first name and last name are in sperate
colums.
I can join combine the two and copy as a value. When I combine them though
there are several extra spaces. Does anyone know what causes this and how
to
fix it? here is an example:

John Smith shows as John Smith

Thanks Mike

Either formula produces a single spaced John Smith in Excel 2003

Yours is shorter<g


Gord

On Fri, 8 Jun 2007 21:23:08 -0400, "Mike G" wrote:

The trim function does not neet the extra &" " in between. The definition
is: removes all spaces from a text string except for a single space between
words. Of course if you need more than one, then you would use " " but it
looks like the OP was looking for one, I am using 2007 version, don't
remember if other versions were different. So =TRIM(a1&b1)

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
How are you joining/combining the two names?

=A1 & B1

=CONCATENATE(A1,A2)

Either method will produce spaces if you have extra spaces in the cell
values.

Try =TRIM(A1 & " " & B2) to return John Smith


Gord Dibben MS Excel MVP


On Fri, 8 Jun 2007 14:50:00 -0700, Jennie

wrote:

I ahve a spreadsheet were the first name and last name are in sperate
colums.
I can join combine the two and copy as a value. When I combine them though
there are several extra spaces. Does anyone know what causes this and how
to
fix it? here is an example:

John Smith shows as John Smith