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!

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!

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