Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Concatenating
When I concatenate two fields, why does a large space appear between both
entries? Is there a setting that I should check out? |
#2
|
|||
|
|||
Do you have leading or trailing spaces in the text you're concatenating?
In article , Metalteck wrote: When I concatenate two fields, why does a large space appear between both entries? Is there a setting that I should check out? |
#3
|
|||
|
|||
Yes, there seems to be spaces. Is there a command I can use to trim them down?
"JE McGimpsey" wrote: Do you have leading or trailing spaces in the text you're concatenating? In article , Metalteck wrote: When I concatenate two fields, why does a large space appear between both entries? Is there a setting that I should check out? |
#4
|
|||
|
|||
One way:
=TRIM(A1 & B1) In article , Metalteck wrote: Yes, there seems to be spaces. Is there a command I can use to trim them down? |
#5
|
|||
|
|||
How do I get a space between the first name and last name using the trim
command? "JE McGimpsey" wrote: One way: =TRIM(A1 & B1) In article , Metalteck wrote: Yes, there seems to be spaces. Is there a command I can use to trim them down? |
#6
|
|||
|
|||
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) In article , Metalteck wrote: How do I get a space between the first name and last name using the trim command? |
#7
|
|||
|
|||
Is this in excel or access?
Linda "Metalteck" wrote in message ... When I concatenate two fields, why does a large space appear between both entries? Is there a setting that I should check out? |
#8
|
|||
|
|||
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). --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Metalteck" wrote in message ... Yes, there seems to be spaces. Is there a command I can use to trim them down? "JE McGimpsey" wrote: Do you have leading or trailing spaces in the text you're concatenating? In article , Metalteck wrote: When I concatenate two fields, why does a large space appear between both entries? Is there a setting that I should check out? |
#9
|
|||
|
|||
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 ----------------------------------------------------------------------------------------------------------------------- Linda "Metalteck" wrote in message ... How do I get a space between the first name and last name using the trim command? "JE McGimpsey" wrote: One way: =TRIM(A1 & B1) In article , Metalteck wrote: Yes, there seems to be spaces. Is there a command I can use to trim them down? |
#10
|
|||
|
|||
LMB,
This is in Excel. -- Regards, John Mansfield http://www.pdbook.com "LMB" wrote: Is this in excel or access? Linda "Metalteck" wrote in message ... When I concatenate two fields, why does a large space appear between both entries? Is there a setting that I should check out? |
#11
|
|||
|
|||
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 "John Mansfield" wrote in message ... LMB, This is in Excel. -- Regards, John Mansfield http://www.pdbook.com "LMB" wrote: Is this in excel or access? Linda "Metalteck" wrote in message ... When I concatenate two fields, why does a large space appear between both entries? Is there a setting that I should check out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a formula for conditional concatenating? | Excel Worksheet Functions | |||
concatenating numbers | Excel Worksheet Functions | |||
concatenating with unequal columns | Excel Discussion (Misc queries) | |||
Concatenating Dates | Excel Worksheet Functions | |||
keep $ formatting when concatenating | Excel Discussion (Misc queries) |