Get instant live expert help on char 10 excel

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

=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
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
I need help from my previous expert. Concerning dynamic char
Solved by D. C. in 29 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
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