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

 
 
 
 
 
(0)
Add to favorites
Office
8/10/2009
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • 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?