T
Tracey
hello
I have 5 columns that I need to concatenate IF there is a value and if the
value isnt already in the other cells i.e:
A B C D E Concatenated (should Read):
Row 1: United Kingdom France Japan United Kingdom Italy United Kingdom,
France , Japan, Italy
Row 2: USA USA USA USA
Row 3: France Singapore Italy Spain France France, Singapore, Italy, Spain,
Row 4: United Kingdom France United Kingdom United Kingdom United
Kingdom United Kingdom, France
the following formula works to a point...
=SUBSTITUTE(TRIM(CONCATENATE(A1," ",B1," ",C1," ",D1," ",E1))," ",", ")
it brings back the following for Row 4 (mentioned above)
Row 4: United, Kingdom, France, United, Kingdom, United, Kingdom, United,
Kingdom
Where I would like it to read: United Kingdom, France
Is this possible?
Many thanks
Tracey
I have 5 columns that I need to concatenate IF there is a value and if the
value isnt already in the other cells i.e:
A B C D E Concatenated (should Read):
Row 1: United Kingdom France Japan United Kingdom Italy United Kingdom,
France , Japan, Italy
Row 2: USA USA USA USA
Row 3: France Singapore Italy Spain France France, Singapore, Italy, Spain,
Row 4: United Kingdom France United Kingdom United Kingdom United
Kingdom United Kingdom, France
the following formula works to a point...
=SUBSTITUTE(TRIM(CONCATENATE(A1," ",B1," ",C1," ",D1," ",E1))," ",", ")
it brings back the following for Row 4 (mentioned above)
Row 4: United, Kingdom, France, United, Kingdom, United, Kingdom, United,
Kingdom
Where I would like it to read: United Kingdom, France
Is this possible?
Many thanks
Tracey