I don't have a clue at what you are really trying to do. the word split can
mean a lot of different things. My firstt impression you werre using some
form of Test-to-columns or importing data. I'm now thinking you are just
spliting a string

for spliting strings

left_piece = left(mystring,instr(mystring,"|") - 1)
right_piece = mid(mystring,instr(mystring,"|") + 1)


for replacement
new_string = replace(mystring,"|","ZZ")



"Tyrone" wrote:

hi Joel,
thank you for your quick reply.
how do you code this? i just started with vba and don't have a clue yet.

regards.

"Joel" wrote:

It is treating the period as a wildcard. One thing you can do is replace the
period with the characters ZZ. Do the split. Then replace ZZ with a period.

"Tyrone" wrote:

hello,
I have a list of datanames with one or more extensions. is it possible to
perform one split only? I should look like:

---------------------
hello|abc.def

instead of:

---------------------
hello|abc|def

thanks in advance.
greetings