Forum Discussion

Copper Contributor

Jan 19, 2022

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?

excel

SergeiBaklan
Jan 19, 2022
pramodraam

That will be easier with

=TEXTJOIN(" > ", 1, D1:G1)

as
concatenate.xlsx11 KB

SergeiBaklan

Diamond Contributor

Jan 19, 2022

pramodraam

Sorry for misprint

=D1 & " > " & E1 & " > " & F1 & " > " & G1

Please check in attached file as well

concatenate.xlsx10 KB

pramodraam

Copper Contributor

Jan 19, 2022

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
Diamond Contributor
Jan 19, 2022
pramodraam

That will be easier with

=TEXTJOIN(" > ", 1, D1:G1)

as
concatenate.xlsx11 KB
- pramodraam
  Copper Contributor
  Jan 20, 2022
  SergeiBaklan Great, this formula did it. Thank you.
  - SergeiBaklan
    Diamond Contributor
    Jan 20, 2022
    pramodraam , you are welcome