Split cell ascii

[dk]

Is there anyway to split up a cell with several words and numbers to
automatically split before the number for a new column or comma

ex: the are going 123/45

split up = the are going, 123/45

 

[Shane Devenshire]

Hi,

where can the number appear - always at the end?, how many numbers can be in
a sentence, more than one set?, do you want commas between all of them?

Could your data look like this: 123 red fox
or like this 123 red fox 456 green grass 890
and what do you do if you have this 123 456 true 432 546

Cheers,
Shane

 

[dk]

always at end? yes commas between ascii

Hi,

where can the number appear - always at the end?, how many numbers can be in
a sentence, more than one set?, do you want commas between all of them?

Could your data look like this: 123 red fox
or like this 123 red fox 456 green grass 890
and what do you do if you have this 123 456 true 432 546

Cheers,
Shane