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