Get instant live expert help on I need help with excel concatenate cells

“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 to concatenate some cells with seperators
Solved by X. J. in 19 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
I need to concatenate several cells in one and separate them by a comma
Solved by D. J. in 13 mins
I need help with excel concatenate formula.
Solved by E. S. in 11 mins
I have 10 alphanumeric cells like 123456789D 123456789F 123456789D 123456789F 123456789014 123456789F 123456789013 123456789F 123456789012 123456789G Sometimes it may be a 2 also I mean 10 values are not a constant. Q: 1 I have to split only numeric that 12 digit values and I need to concatenate Q:2 I have to split that 10 digit alphanumeric cells and I need to concatenate Q:3 above example I have given 10 cells sometimes it may be less that time I shouldn't get any error in concatenate Please help me out of these. I had tried bunch of times using Len and if else functions
Solved by S. B. in 21 mins