Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 12th 08, 05:34 AM posted to microsoft.public.excel.newusers
dk dk is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 129
Default 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   Report Post  
Old November 12th 08, 08:13 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default 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   Report Post  
Old November 12th 08, 05:16 PM posted to microsoft.public.excel.newusers
dk dk is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
split a cell diagonally in excell - a calendar -2 dates in 1 cell Vicki Excel Discussion (Misc queries) 1 October 31st 06 03:40 PM
Ascii in a cell Mr Doggo Excel Discussion (Misc queries) 4 September 3rd 06 12:16 AM
Split cell help! davids Excel Discussion (Misc queries) 4 March 23rd 06 02:34 AM
How can I split one cell into two cell parts (upper & lower)? Desert Sparkle Excel Discussion (Misc queries) 0 January 5th 06 10:22 PM
Is there a way I can split last name first name in one cell PeterM Excel Discussion (Misc queries) 5 June 3rd 05 03:05 PM


All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017