“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=IF(A3<>"",IF(AND(OR(B3<>"","Inclusive Cost Summary"&CHAR(10)&"Total Price "&TEXT(P3,"$0.00")&CHAR(10)&"Total Tax and Fees "&TEXT(Q3,"$0.00")&CHAR(10)&"Total Freight "&TEXT(R3,"$0.00")),""))

Solved by B. C. in 18 mins

In GI1 char 17,4 I have 2500 why do get 125 using the formula below =IF(MID(GI1,17,4)>2600,125,150)

Solved by C. D. in 29 mins

I need help from my previous expert. Concerning dynamic char

Solved by D. C. in 29 mins

I want to combine two cells with a LineBreak between but when I add CHAR(10) it doesn't affect and they come together

Solved by X. Y. in 22 mins

Hi, I am using the following formula to merge a column of cells into a single cell with each value separated by a return: =CONCATENATE(TRANSPOSE(cell range from a different sheet)&CHAR(10)) Once I write the formula, I have been highlighting the inner nested formula (Transpose through Char(10)) and hitting F9. Then, I delete the {} brackets and run the whole CONCATENATE formula on the output of the Transpose formula. My question is twofold: 1. How can I do this formula if for one of the cell ranges there are more than the maximum characters for a formula? 2. Is there a faster way to do this than manually running the inner formula first?

Solved by C. Q. in 21 mins