Parse a Single Column into Multiple Columns

Parses comma-separated values in a spreadsheet column into multiple columns (for example, the value Olympia, WA becomes two separate values: Olympia and WA).

Add to favorites
E-mail Twitter Digg Facebook
  • Suppressing Excel Prompts
    1 Posts | Last post October 12, 2012
    • This bit of script helped a lot, but I get a prompt from excel that I don't want occurring. Each time I call the method TextToColumn, I receive the prompt: "Do you want to replace the contents of the destination cells?" 
      This will always be yes, so how do I suppress the prompt from appearing?