View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
dk dk is offline
external usenet poster
 
Posts: 129
Default Split cell ascii

always at end? yes commas between ascii

"Shane Devenshire" wrote:

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" wrote:

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