Hello,
I’m attempting to extract the number after FW, (9,10, 11) so I can add them to something else. The length of the cell including spaces is 17 for single digits (1-9) and 18 for double digits (10-15)
I tried this which works for double digits but not getting the correct results.
Any ideas?
Thanks
I’m attempting to extract the number after FW, (9,10, 11) so I can add them to something else. The length of the cell including spaces is 17 for single digits (1-9) and 18 for double digits (10-15)
I tried this which works for double digits but not getting the correct results.
Any ideas?
Thanks
South Atlantic.xls | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
1 | ||||||
2 | 2/1/2010(FW1) | 17 | ||||
3 | 2/8/2010(FW2) | 16 | ||||
4 | 2/15/2010(FW3) | 15 | ||||
5 | 2/22/2010(FW4) | 14 | ||||
6 | 3/1/2010(FW5) | 13 | ||||
7 | 3/8/2010(FW6) | 12 | ||||
8 | 3/15/2010(FW7) | 11 | ||||
9 | 3/22/2010(FW8) | 10 | ||||
10 | 3/29/2010(FW9) | 9 | ||||
11 | 4/5/2010(FW10) | 10 | ||||
12 | 4/12/2010(FW11) | 11 | ||||
13 | 4/19/2010(FW12) | 12 | ||||
14 | 4/26/2010(FW13) | 13 | ||||
15 | 5/3/2010(FW14) | 14 | ||||
16 | 5/10/2010(FW15) | 15 | ||||
17 | 5/17/2010(FW16) | 16 | ||||
18 | 5/24/2010(FW17) | 17 | ||||
19 | 5/31/2010(FW18) | 18 | ||||
20 | 6/7/2010(FW19) | 19 | ||||
Sheet1 |