Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Concatenate
I have four columns to combine and I use the concatenate function. One of my
columns has either 3,4 or 5 characters. When I concatenate, there are spaces in the middle of the end product. How do I get those spaces to disappear in column 1? I can't just set the length of the column to 3 or 4 or 5 characters because I need that varied length. I just don't want the spaces at the end. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Concatenate
With
A1: "Alpha " B1: "Bravo " C1: "Charlie " (all without the quotes, of course) This formula scrubs the spaces from the end result: D1: =SUBSTITUTE(A1&B1&C1," ","") In that example, it returns "AlphaBravoCharlie" Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Susie" wrote in message ... I have four columns to combine and I use the concatenate function. One of my columns has either 3,4 or 5 characters. When I concatenate, there are spaces in the middle of the end product. How do I get those spaces to disappear in column 1? I can't just set the length of the column to 3 or 4 or 5 characters because I need that varied length. I just don't want the spaces at the end. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Concatenate
=TRIM(B1&C1&D1&E1) entered in A1
Gord Dibben MS Excel MVP On Tue, 12 Feb 2008 16:23:02 -0800, Susie wrote: I have four columns to combine and I use the concatenate function. One of my columns has either 3,4 or 5 characters. When I concatenate, there are spaces in the middle of the end product. How do I get those spaces to disappear in column 1? I can't just set the length of the column to 3 or 4 or 5 characters because I need that varied length. I just don't want the spaces at the end. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Concatenate
Not considered good to post in muliple groups
Tyro "Susie" wrote in message ... I have four columns to combine and I use the concatenate function. One of my columns has either 3,4 or 5 characters. When I concatenate, there are spaces in the middle of the end product. How do I get those spaces to disappear in column 1? I can't just set the length of the column to 3 or 4 or 5 characters because I need that varied length. I just don't want the spaces at the end. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate | Excel Discussion (Misc queries) | |||
Help with concatenate | Excel Worksheet Functions | |||
Help with CONCATENATE! | Excel Discussion (Misc queries) | |||
Concatenate | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |