Forum Discussion
Solved
How to trim and concatenate data in different cells?
I need to fill cell C with data from D, E, F and G cells with > separating them like Furniture > Cabinets & Storage. I'm looking for the formula to do it. Could you please help me with it?
Thanks a lot. It is working, but it shouldn't result in last 2 > > "Furniture > Cabinets & Storage > >" If there is no data in the cell, it shouldn't add >. Can you please change your formula to address this?
SergeiBaklan Great, this formula did it. Thank you.
pramodraam , you are welcome