Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Split cell ascii
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Split cell 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 "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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
Ascii in a cell | Excel Discussion (Misc queries) | |||
Split cell help! | Excel Discussion (Misc queries) | |||
How can I split one cell into two cell parts (upper & lower)? | Excel Discussion (Misc queries) | |||
Is there a way I can split last name first name in one cell | Excel Discussion (Misc queries) |