G
Guest
When I concatenate two fields, why does a large space appear between both
entries? Is there a setting that I should check out?
entries? Is there a setting that I should check out?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
Do you have leading or trailing spaces in the text you're concatenating?
G
Guest
Yes, there seems to be spaces. Is there a command I can use to trim them down?
J
JE McGimpsey
One way:
=TRIM(A1 & B1)
=TRIM(A1 & B1)
G
Guest
How do I get a space between the first name and last name using the trim
command?
command?
J
JE McGimpsey
You don't. You said you had a lot of spaces in between. TRIM() will
remove all but one.
If you need to have at least one space, try
=TRIM(A1 & " " & B1)
remove all but one.
If you need to have at least one space, try
=TRIM(A1 & " " & B1)
L
LMB
Is this in excel or access?
Linda
Linda
D
David McRitchie
When you concatenate you could use TRIM
=TRIM(A1 & B1)
The Excel TRIM will remove spaces from left and right, and excess spaces in between.
The VBA TRIM will only remove spaces from left and right.
You might be interested in using a macro, see the TRIMALL macro at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
It would be in your best interest if you first determined WHY you have
excess spaces, but the TRIMALL macro will trim text constnants (not formulas).
=TRIM(A1 & B1)
The Excel TRIM will remove spaces from left and right, and excess spaces in between.
The VBA TRIM will only remove spaces from left and right.
You might be interested in using a macro, see the TRIMALL macro at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
It would be in your best interest if you first determined WHY you have
excess spaces, but the TRIMALL macro will trim text constnants (not formulas).
L
LMB
Here is what I have used for Concatenating names but I am new to Excel so I
may not fully understand what you want.
---------------------------------------------------------------------------------------------------------------------
Where Cell C3 is the First Name and Cell B3 is the Last Name.
=CONCATENATE(C3," ",B3)
Will yield..............FirstName LastName
----------------------------------------------------------------------------------------------------------------------
Where Cell B3 has the Last Name and Cell B3 has the First Name.
=CONCATENATE(B3,", ",C3)
Will yield.............LastName, FirstName
may not fully understand what you want.
---------------------------------------------------------------------------------------------------------------------
Where Cell C3 is the First Name and Cell B3 is the Last Name.
=CONCATENATE(C3," ",B3)
Will yield..............FirstName LastName
----------------------------------------------------------------------------------------------------------------------
Where Cell B3 has the Last Name and Cell B3 has the First Name.
=CONCATENATE(B3,", ",C3)
Will yield.............LastName, FirstName
G
Guest
LMB,
This is in Excel.
This is in Excel.
L
LMB
Thanks, John, I figured that out when I looked to see where I was. I have
been spending a lot of time in the access groups and forgot where I was.
Linda
been spending a lot of time in the access groups and forgot where I was.
Linda