Concatenate Formulas with HTML

The following post is to test Concatenate formulas with added HTML to import vendor data for long descriptions. I am going to include several examples that can be used depending on the provided info. 

 

Demo formula:

=CONCATENATE(E6," ",G6," ",H6," ",I6," ",T6," ")

 


 

I’m going for something like this: 

This is a product description. This is a product description. This is a product description. This is a product description. This is a product description. (E6). 

FEATURES

  • Feature 1
  • Feature 2
  • Feature 3

 

FABRICS

  • Fabric

Continue Reading

 

 

The HTML will look like this: 


 

IF there is 1 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 1 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 1 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6," </li></ul> ")

 


 

IF there is 2 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li></ul> ")

IF there is 2 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li><li> ",U6," </li></ul> ")

IF there is 2 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6," </li></ul> ")

 


 

IF there is 3 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li></ul> ")

IF there is 3 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li><li> ",U6," </li></ul> ")

IF there is 3 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6," </li></ul> ")

 


 

IF there is 4 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 4 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 4 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")

 


 

IF there is 5 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 5 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 5 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")

 


 

IF there is 6 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 6 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 6 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")

 


 

IF there is 7 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 7 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 7 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")

 


 

IF there is 8 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, "</li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 8 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, "</li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 8 features and 3 fabrics the formula could be:

=CONCATENATE(E169," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G169," </li><li> ",H169," </li><li> ",I169," </li><li> ",J169," </li><li> ",K169," </li><li> ",L169," </li><li> ",M169," </li><li> ",N169, "</li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T169," </li><li> ",U169," </li><li> ", V169,"</li></ul> ")


 

IF there is 9 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 9 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 9 features and 3 fabrics the formula could be:

=CONCATENATE(E205," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G205," </li><li> ",H205," </li><li> ",I205," </li><li> ",J205," </li><li> ",K205," </li><li> ",L205," </li><li> ",M205," </li><li> ",N205," </li><li> ",O205," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T205," </li><li> ",U205," </li><li> ",V205," </li></ul> ")

 


 

IF there is 10 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 10 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 10 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6, "</li></ul> ")

 


 

IF there is 11 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 11 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 11 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6, "</li></ul> ")

 


 

IF there is 12 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li><li> ",R6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 12 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li><li> ",R6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 12 features and 3 fabrics the formula could be:

=CONCATENATE(E197," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G197," </li><li> ",H197," </li><li> ",I197," </li><li> ",J197," </li><li> ",K197," </li><li> ",L197," </li><li> ",M197," </li><li> ",N197, " </li><li> ",O197," </li><li> ",P197," </li><li> ",Q197, " </li><li> ",R197, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T197," </li><li> ",U197," </li><li> ",V197, "</li></ul> ")

 


 

This reference list should work for my current Columbia spreadsheet. Keeping in mind the letter will be the same but the numbers will change depending on the row they need to apply to. Excel will color code selected cells, if the cell ID is not colored this is an indication of where you made a mistake in your formula. 

 

Finished Reading

Posted in Data/Excel, Tutorials.
Loading Facebook Comments ...

Join the conversation

Your email address will not be published. Required fields are marked *