Add Values of Other Cells if Not Blank

[thanksamillion101]

Hello All, another formula, needed! The formula I need will return the text values of other cells, if not blank. Any of the cells in each row can be blank or have text and I need to be able to create the File Name from each cell according to cell content. Thank you in advance! Hope I explained well enough. Highlighted Column A in the image is where I will need the formulas and shows the return from each row with the formula.

 

[thanksamillion101]

Hello All, another formula, needed! The formula I need will return the text values of other cells, if not blank. Any of the cells in each row can be blank or have text and I need to be able to create the File Name from each cell according to cell content. Thank you in advance! Hope I explained well enough. Highlighted Column A in the image is where I will need the formulas and shows the return from each row with the formula.

View attachment 73534

This formula seems to work, but if you have anything different or would change, please advise, thank you!
IF(D2<>"",D2,"")&IF(H2<>"",H2,"")&IF(I2<>"",I2,"")