Get instant live expert help on how to separate comma separated values in excel

“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 a formula to find duplicates from Column A to new Column with related data in comma separated manner Description - Column A has some duplicate values and its assocaited values are in Column B&C My requirement is to remove duplicate values from Column A and associated values should be moved into one cell with Comma separated
Solved by S. L. in 13 mins
Having trouble with a VLOOKUP formula. My reference cells have different values in them (from 1 to 6 comma separated values). I keep getting a REF or N/A error...
Solved by F. C. in 17 mins
In column A I have a list of duplicated values and in column B I have Unique values, I need a Formulato remove the duplicated value in column A and creates a comma separated value of removed value in Column B I need to attach the Excel files
Solved by X. H. in 20 mins
i have a document filled with numbers separated by spaces and commas. i want the numbers separated by spaces to be in different cells, but after every comma, i go to a new row. how do i do that?
Solved by F. A. in 29 mins
Combing formulas to separate space or comma
Solved by E. A. in 30 mins