Get instant live expert help on how to concatenate
“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
I don't know how to use concatenate with different sheets
Solved by D. J. in 30 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
In concatenate how to enter a carriage return between, say, name and city
Solved by T. E. in 22 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
Need to concatenate two columns while keeping zeros
Solved by V. F. in 25 mins