I have a couple text files that are comma delimited that I have imported into excel.
My problem is that a handful of the rows had "extra" commas.. resulting in extra columns.
example:
San Jose, CA, shirts, orange, green, blue,
In that case, I'd want to merge "orange, green, blue" into one cell.
Is there a function to perhaps highlight the columns side by side and merge them all into ONE cell "orange green blue"
Thank you in advance for your help.
My problem is that a handful of the rows had "extra" commas.. resulting in extra columns.
example:
San Jose, CA, shirts, orange, green, blue,
In that case, I'd want to merge "orange, green, blue" into one cell.
Is there a function to perhaps highlight the columns side by side and merge them all into ONE cell "orange green blue"
Thank you in advance for your help.