Thread: number only
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom taol tom taol is offline
external usenet poster
 
Posts: 52
Default 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!