Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
number only
[a1:a8] data is below. aaaa ppp 22,400 bbb dd ddd 7,700 ffff 1,630 gg 3,680 xxxx 858 ccc vvv 117 bbbbbb 351 ggggg 78 i want to make in [b1:b8] as below. 22400 7700 1630 3680 858 117 351 78 i want to know using excel self embedded function. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
number only
This can be done quickly right on the spreadsheet. Select the data(A1:A8),
on the menubar choose Data/Text to Columns. Choose Delimited, Space. In E1 put =SUM(A1:D1) and drag down to row 8. Or record a macro of you doing the above. Mike F "tom taol" wrote in message ... [a1:a8] data is below. aaaa ppp 22,400 bbb dd ddd 7,700 ffff 1,630 gg 3,680 xxxx 858 ccc vvv 117 bbbbbb 351 ggggg 78 i want to make in [b1:b8] as below. 22400 7700 1630 3680 858 117 351 78 i want to know using excel self embedded function. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
number only
On Tue, 18 Jan 2005 02:42:20 -0800, tom taol wrote:
[a1:a8] data is below. aaaa ppp 22,400 bbb dd ddd 7,700 ffff 1,630 gg 3,680 xxxx 858 ccc vvv 117 bbbbbb 351 ggggg 78 i want to make in [b1:b8] as below. 22400 7700 1630 3680 858 117 351 78 i want to know using excel self embedded function. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Enter the formula below in B1 and copy/drag it down to B8: =--MID(TRIM(A1),FIND("~",SUBSTITUTE(TRIM(A1)," ","~", LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ","")))),256) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif number is greater than a number but less than another number | Excel Discussion (Misc queries) | |||
How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |