Concatenating Columns

paul29berks

Active Member
Joined
Mar 15, 2004
Messages
293
I am trying to concatenate values from seperate columns. Which is fine, however if there are no values in any of these columns I wish to include three dots (...)

So for example

Column1 Column 2 Column 3

B11 Europe

would concatenate as:

B11Europe...

Thanks
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Fausto

New Member
Joined
Jul 28, 2004
Messages
44
Hello

This function should do the trick

=IF(C13<>"",C13,"…")&IF(D13<>"",D13,"…")&IF(E13<>"",E13,"…")

Hope that is what you are looking for!
 

paul29berks

Active Member
Joined
Mar 15, 2004
Messages
293
Sorry just a further question.

If I wanted to add a further . after each cell how could i do this?

i.e

if c13 is null then ... followed by a . then if d13 is null then ... followed by a . etc etc

Thanks
 

thunderfoot

Board Regular
Joined
May 28, 2004
Messages
229
=IF(C13<>"",C13,"…")&"."&IF(D13<>"",D13,"…")&"."&IF(E13<>"",E13,"…")&"."
 

Watch MrExcel Video

Forum statistics

Threads
1,118,287
Messages
5,571,318
Members
412,382
Latest member
Langtn02
Top