Split cell ascii

D

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
 
S

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
 
D

dk

always at end? yes commas between ascii

Shane Devenshire said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top