Ignore Empty Cells?! Help!

[Alex Caldecott]

Very fresh Excel user here, sorry.

Currently working on a CSV import for our ecommerce site.

I have a selection of columns that contain text and I'm trying to make these into a list of bullet points.

The columns in my spread sheet are U, V, W, X, Y, Z, AA, AB, AC, AD, AE, AF & AG and the formula I'm using is this -

=CONCATENATE("<ul><li>",U2,"</li><li>",V2,"</li><li>",W2,"</li><li>",X2,"</li><li>",Y2,"</li><li>",Z2,"</li><li>",AA2,"</li><li>",AB2,"</li><li>",AC2,"</li><li>",AD2,"</li><li>",AE2,"</li><li>",AF2,"</li><li>",AG2,"</li></ul>")


The issue I have is that some of the cells are blank and this formula then creates a bullet point with no text.

How do I make this formula ignore blank cells??

Would greatly appreciate any help!

 

[Fluff]

Hi & welcome to MrExcel.
How about

="<ul><li>"&TEXTJOIN("</li><li>",,U2:AG2)&"</li></ul>"

 

[Alex Caldecott]

This seems to have worked perfectly... You, sir, are a life saver

 

[Fluff]

You're welcome & thanks for the feedback.