Hey all,
I have been trying to create a formula to concat 7 cells in a row, skip blanks, and add some HTML tags to it. I know the formaula wont work below but I have put it back to basic and need help to get it to the next step. Details below:
=CONCAT("[ul][li]",IF(A2="","",A2),"[/li][li]",IF(B2="","",B2),"[/li][li]",IF(C2="","",C2),"[/li][li]",IF(D2="","",D2),"[/li][li]",IF(E2="","",E2),"[/li][li]",IF(F2="","",F2),"[/li][li]",IF(G2="","",G2),"[/li][/ul]")
<tbody>
</tbody>
Row 1 is correct as there are 7 features. Row 2 is wrong and it should finish after feature 5 and should look like this:
<tbody>
</tbody>
Also, is there any recommendation on sites etc to learn the next level of excel including VBA's etc.
Many thanks in advance.
Chris
EDIT: i had to replace <> with [] due to formatting issues.
I have been trying to create a formula to concat 7 cells in a row, skip blanks, and add some HTML tags to it. I know the formaula wont work below but I have put it back to basic and need help to get it to the next step. Details below:
=CONCAT("[ul][li]",IF(A2="","",A2),"[/li][li]",IF(B2="","",B2),"[/li][li]",IF(C2="","",C2),"[/li][li]",IF(D2="","",D2),"[/li][li]",IF(E2="","",E2),"[/li][li]",IF(F2="","",F2),"[/li][li]",IF(G2="","",G2),"[/li][/ul]")
Feature1 | Feature2 | Feature3 | Feature4 | Feature5 | Feature6 | Feature7 | Result | ||
Round | Square | Flat | Edge | Great | Little | Solid |
<tbody> </tbody> | ||
Round | Square | Flat | Edge | Great | <tbody> </tbody>
<tbody> </tbody> |
<tbody>
</tbody>
Row 1 is correct as there are 7 features. Row 2 is wrong and it should finish after feature 5 and should look like this:
So at the start of every row is [ul][li] then between each feature is [/i][li] and then at the lend of the last feature it is [/li][/ul] |
<tbody>
</tbody>
Also, is there any recommendation on sites etc to learn the next level of excel including VBA's etc.
Many thanks in advance.
Chris
EDIT: i had to replace <> with [] due to formatting issues.
Last edited: