View Single Post
 
Old 07-20-2017, 03:11 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

The text to column dialogue has a check box next to the delimiter choices that is Treat consecutive delimiters as one
When checked it adds ConsecutiveDelimiter:=True into the line of code.
Reply With Quote