View Single Post
 
Old 07-08-2020, 05:15 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,980
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

kevin

The examples used a comma delimiter but you could use any (non-used) character you wanted as the separator. If you wanted to change to something else you could eg
Code:
StrOut = "bananas|watermelon|oranges, apples, and pears"
For i = 0 To UBound(Split(StrOut, "|"))
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote