![]() |
|
|
|
#1
|
|||
|
|||
|
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. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sorting in protected worksheet | john64 | Excel | 2 | 12-31-2016 12:04 PM |
Cell formating on Protected worksheet
|
AHB | Excel Programming | 2 | 02-27-2012 10:25 AM |
Insert/Paste Picture into Protected Worksheet
|
udea | Excel | 1 | 02-06-2012 07:43 PM |
Word mail merge from a protected Excel worksheet
|
Platform | Mail Merge | 10 | 09-28-2011 05:12 AM |