Split use arterisk criteria

[daboho]

In A1: A50 i have data
A1= streat bybway 01/04 character split bynumber
I want split first delimiter is 01/04 then in B1 = streat bybway 01/04 and C1= chracter ,D1= split,E1=bynumber
In A2 variant text(different number position) i ask i want first split is bynumeric then by space
How to split by number

Please Login or Register  to view this content.

[jindon]

In A1: A50 i have data
A1= streat bybway 01/04 character split bynumber
I want split first delimiter is 01/04 then in B1 = streat bybway 01/04 and C1= chracter ,D1= split,E1=bynumber

Please Login or Register  to view this content.

[daboho]

Jindon if use split by criteria arterisk like * *,## it can do
I dont understand use vbscript thank before

[jindon]

Jindon if use split by criteria arterisk like * *,## it can do

I don't understand what you are talking about.

I dont understand use vbscript thank before

That's your problem, not mine.

[daboho]

Thank you jindon i has a little understand use createobject("vbscript.regexp")

[jindon]

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.