Get instant live expert help on I need help with excel concatenate line break

“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

I need help with excel concatenate formula.
Solved by E. S. in 11 mins
I recently exported a bibliography from word into excel via text. The titles, all between and have varying lengths therefore diffent columns. Using concatenate how can I make a formula that only concatenates between cells where appears, i.e.a concatenate formula of varying columns?
Solved by T. Q. in 28 mins
not able to break excel link to external file
Solved by O. J. in 22 mins
I'm having trouble with CONCATENATE formula writing to create "Full Address" on 2 lines (using CHAR10). Here's the formula I've written, for which I keep getting an error message (and yes, I have a main Street Address plus a Street Address 2, i.e., apartment # and the like as part of the first line of the address, before then having the 2nd line consist of city, state and zip): =CONCATENATE(AC,", ",AD,CHAR(10)AE,", ",AF," ",AG,)
Solved by G. B. in 18 mins
Could you please explain what is being referenced in the follow string? I am familiar with using INDIRECT and CONCATENATE together. =INDIRECT(CONCATENATE("'Sheet Name'!",K$1&$A6))
Solved by B. L. in 24 mins