Joe_Fox
Well-Known Member
Hello,
I have some cells I want to merge into one cell, for example:
figure 1.
I want column E to be filled with the merged data but with each cell being separted by a semi-colon, so it should look like this:
figure 2.
I am using the formula E1=A1&";"&A2&";"&A3&";"&A4.
My problem is that when a cell is blank, like C2, the result is that a semi-colon is placed in the merged cell, resulting in this:
figure 3.
How can I make the merged cell look like it does in figure 2?
I think I need to use some IF functions but how do I say ignore blanks?
Any help would be hugely appreciated.
Thanks,
Joe_Fox
I have some cells I want to merge into one cell, for example:
figure 1.
Code:
A B C D
1 23 66 24 87
2 34 56 67
I want column E to be filled with the merged data but with each cell being separted by a semi-colon, so it should look like this:
figure 2.
Code:
A B C D E
1 23 66 24 87 23;66;24;87
2 34 56 67 34;56;67
I am using the formula E1=A1&";"&A2&";"&A3&";"&A4.
My problem is that when a cell is blank, like C2, the result is that a semi-colon is placed in the merged cell, resulting in this:
figure 3.
Code:
A B C D E
1 23 66 24 87 23;66;24;87
2 34 56 67 34;56;;67
How can I make the merged cell look like it does in figure 2?
I think I need to use some IF functions but how do I say ignore blanks?
Any help would be hugely appreciated.
Thanks,
Joe_Fox