Good day to you all.

I'm relatively new to the VBA scene - hence this post.

I'm looking for a way to split a string of text, in a large range, using several different delimiters. It is important to keep the delimiters as they were as they are needed for a later macro.

EXAMPLE:

My data:
Toast!Bread
Sun?Moon

After Macro (_ represents string split into 2 columns):
Toast _ Bread
Sun _ Moon

Thank you for any advice you can give me.