sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 996
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I have huge data in excel from A1 to IV349 and in between, i have the number 21%,.012
so i need all numbers in the whole number columns A and B are the row data and the output i need in columns E and F green highlighted data
I need data wiht no letters
I have huge data in excel from A1 to IV349 and in between, i have the number 21%,.012
so i need all numbers in the whole number columns A and B are the row data and the output i need in columns E and F green highlighted data
I need data wiht no letters
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | 15 | 20 | 15 | 20 | ||||
2 | 9 | 16 | 9 | 16 | ||||
3 | 16 | 19 | 16 | 19 | ||||
4 | 12 | 18 | 12 | 18 | ||||
5 | 21 | 29B | 21 | 29 | ||||
6 | 13 | 16 | 13 | 16 | ||||
7 | 0.15 | 0.17 | 15 | 17 | ||||
8 | 16 | 15 | 16 | 15 | ||||
9 | 14 | 17 | 14 | 17 | ||||
10 | 10 | 11 | 10 | 11 | ||||
11 | 0.09 | 0.16 | 9 | 16 | ||||
12 | 11 | 15 | 11 | 15 | ||||
13 | 9 | 13 | 9 | 13 | ||||
14 | 0.1 | 0.13 | 10 | 13 | ||||
15 | 0.16 | 0.17 | 16 | 17 | ||||
16 | 0.09 | 0.09 | 9 | 9 | ||||
17 | 0.19 | 25%B | 19 | 25 | ||||
18 | 0.09 | 0.08 | 9 | 8 | ||||
19 | 0.15 | 0.13 | 15 | 13 | ||||
20 | 0.04 | 0.09 | 4 | 9 | ||||
21 | 17 | 19 | 17 | 19 | ||||
22 | 10 | 11 | 10 | 11 | ||||
23 | 23%B | 0.21 | 23 | 21 | ||||
24 | 0.12 | 0.17 | 12 | 17 | ||||
25 | 0.14 | 21%BD | 14 | 21 | ||||
26 | 0.09 | 0.11 | 9 | 11 | ||||
27 | 0.12 | 0.16 | 12 | 16 | ||||
28 | 0.09 | 0.1 | 9 | 10 | ||||
29 | 17 | 19 | 17 | 19 | ||||
30 | 11 | 8 | 11 | 8 | ||||
31 | 19 | 21 | 19 | 21 | ||||
Sheet1 |