WISDOMBYDATA
  • BLOG
    • Blog Guide
    • Blog History
  • EXCEL
    • Functions & Formulas
    • VBA & Macros
    • VLOOKUP
    • Pivot Tables
    • Conditional Formatting
    • Tricks & Shortcuts
  • BI
    • SAP BOBJ/BW
    • Tableau
  • SQL
  • ABOUT
    • About WBD
    • About Me

book1.xlsx
File Size: 11 kb
File Type: xlsx
Download File

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)
​

Powered by Create your own unique website with customizable templates.
  • BLOG
    • Blog Guide
    • Blog History
  • EXCEL
    • Functions & Formulas
    • VBA & Macros
    • VLOOKUP
    • Pivot Tables
    • Conditional Formatting
    • Tricks & Shortcuts
  • BI
    • SAP BOBJ/BW
    • Tableau
  • SQL
  • ABOUT
    • About WBD
    • About Me