Forum Discussion
Trying to simplify Formula
Hi, I am using the 'CONCATENATE' formula to pull data from different cells into one. I also need to include Double Double quotations around each field and include a Comma between each piece o...
This might work for you if you have 365:
=LET(quotes,CHAR(34)&CHAR(34),joined,REDUCE("",A2:Q2,LAMBDA(a,v,a&",""es&v"es)),REPLACE(joined,1,1,""))
If you have 365 but no access to REDUCE, you could also simplify the formula with LET.