LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Seperating Numbers

Hi,

This is an example of what I am trying to do:
In one cell I have "=4+6+12+18+4+5+8+7" (so the result of this cell would be
"64").
Now, I would like to have all of these numbers to be sorted and separated in
one row (or column) next to each other (like "4","6","12", ... Etc.)
how is this possible with or without using VBA?

Thanks for your future inputs.


 
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
Seperating Text from Numbers in a cell MaryJ Excel Worksheet Functions 8 September 2nd 09 10:04 AM
excel, seperating numbers and text, macro Gene Shackman Excel Discussion (Misc queries) 3 January 12th 09 01:07 PM
Seperating numbers from text mns Excel Discussion (Misc queries) 2 July 24th 08 10:52 AM
Seperating First and Last Names WilsonLA Excel Discussion (Misc queries) 4 April 12th 06 05:28 PM
Seperating Numbers from Letters in Excel Tel Excel Worksheet Functions 7 March 23rd 06 11:36 PM


All times are GMT +1. The time now is 07:43 AM.

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

About Us

"It's about Microsoft Excel"