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!”
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