Forum Discussion
pramodraam
Jan 19, 2022Copper Contributor
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?
7 Replies
- SergeiBaklanDiamond Contributor
- pramodraamCopper Contributor@sergei, I tried your formula but it isn't working.
- SergeiBaklanDiamond Contributor
Sorry for misprint
=D1 & " > " & E1 & " > " & F1 & " > " & G1
Please check in attached file as well