Concatenate

S

Susie

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.
 
R

Ron Coderre

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate error 3
Excel Concatenate with line breaks but ignore blank cells 3
Split column contents (de-concantenate) 7
Concatenating two variable fields into a static length text field 2
Excel Concatenate cell data from column based on criteria in adjacent column 2
concatenate tables into html tables 1
Concatenate first, middle and last names 1
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6

Top