VBA Code to Delimit Strings with multiple criteria

[ivhee00]

Hi Guys,

Can you help me parse the strings on the attached sample file.

Thanks in advance.

[jindon]

Try

Please Login or Register  to view this content.

[jewelsharma]

Maybe something like this, to handle multiple delimiters.

Please Login or Register  to view this content.

[ivhee00]

Hi Jewelsharma,

Thanks so much for the help.. I used your code for the meantime and just replace " " to "/".

Hi Jindon,

Thanks you so much for the help. I want to use your code but my data doesn't always start with a number and it didn't work if it start with a word. Can you help me on this..

[jindon]

Perhaps

Please Login or Register  to view this content.

[ivhee00]

Thanks guys! You are amazing.