concatenation

[Rhon Alvarez]

Hi Team,

Please help me create concatenate formula which would extract only cells with data and disregard those blanks for every row in an excel file.

I have attached the file for your reference and thank you in advance.


Rhon

 

[NARAYANK991]

Hi ,

I assume there will always be 5 columns.

See the attached file.

Narayan

 

[Rhon Alvarez]

Hello Narayan,

Thanks, this helps a lot. I have a question though, should I add additional columns, I just have to repeat the formula? there maybe possibilities that additional requirements may be needed in the future....

Thanks again....

 

[NARAYANK991]

Hello Narayan,

Thanks, this helps a lot. I have a question though, should I add additional columns, I just have to repeat the formula? there maybe possibilities that additional requirements may be needed in the future....

Thanks again....

Hi ,

I hope you will not go beyond the limits of the IF function !

As long as you are within the limits , you can use the same technique to extend the formula to more columns ; the formula will become cumbersome , but I think it is still a simple formula and readable / understandable.

Narayan