Text strings separated with "/", ",", "-" or "&"

Hello all, can I ask a vba question? I have a column A which contains all kinds of text strings. I noticed that a lot of them are separated by , / & or -.

North, Central, South Europe
North / Central / South Europe
North & Central & South Europe
North - Central - South Europe

I need a UDF function to check it. If the text string contains no special characters (, / & -), then return the original cell value. Otherwise, return the far right text string separated by any of the 4 characters. For example, the North / Central / South Europe will be returned as South Europe.

I'm very new to VBA so sorry for my trouble.

Please Login or Register  to view this content.

Great thanks. It is really interesting. Well learned

THANK both! Very appreciate your help.