In my previous two blog posts I demonstrated how to Concatenate multiple cells and remove unwanted commas between values using a formula and a macro.
While this approach showed to be very effective, some viewers contacted me and stated that the aforementioned methods do not work properly if a cell contains more than one words (i.e. if there is a space in the cell).
Since I aim to please my audience, this week I will be providing the solution to this anomaly.
Consider the data set below. Take notice that some cells in this data set contain more than more than one word (e.g. Las Vegas, New York, New Jersey)