Parsing numbers in strings/numbers concatenated together - CONT'D

[twckfa16]

A couple days ago, a user supplied me with the below code that worked but it seems like I hit a snag.
The objective is to loop through a range(cells contain number and/or string or possibly just numbers) and
no matter what order they are in put them in sequential order. File is attached.

Please Login or Register  to view this content.

So if the sheet starts out like this:

1500 b= b
1501 c = c
1502 d = d
1503 e = e
14971498
1499 a = a
1504 f = f

this is the result:

1497
1498
1499 a = a
1500 b= b
1501 c = c
1502 d = d
1503 e = e
1504 f = f

Now - if I put a character between 1497r1498 for example, I get:

1497r1498

Is there a way I can still have that character and get:

1497r
1498

Thank you

[twckfa16]

Bumping up this thread.

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

[jindon]

This should do.

Please Login or Register  to view this content.

[twckfa16]

Thank you both of you...these ideas seemed to work....how about for these scenarios?

I'm thinking now that I should have said this earlier - sorry about that.

1498ccc. "bbb1497ccc.1499cccc.

Can I get:

1497ccc. "bbb
1498ccc.
1499cccc.

Or:

222 aaa ll224bbbmm
223 aaa "
221 mmm "

Can I get:
221 mmm "
222 aaa ll
223 aaa "
224 bbbmm

Just trying to put random stuff in there.

I was really wasn't clear on this and I apologize.

Thank you.

[twckfa16]

First one should be:

1497ccc.
1498ccc. "bbb
1499cccc.

oops

[jindon]

Post a workbook.

[twckfa16]

Soory about that.