aka_krakur
Active Member
- Joined
- Jan 31, 2006
- Messages
- 438
I have a column in a worksheet that looks like this:
I am looking to extract only the numbers in the last portion of the data in these fields.
for example, in (A2) RX .014 ACCULINK II 8/30 FDA I really only need the 8/30. I could always go with the simple =right(A2,8). However, looking at the multiple variations in this column, I really want to find out if there is a more complex formula to extract only the numbers. For example if I could get the 8 in one column and the 30 in another, as one is diameter and one is length.
But I'd be happy with being able to extract only the 8/30 because I can always do a text to columns based off the / later.
Please help if you can.
Thanks
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | PART_NAME | |||||
2 | RX.014ACCULINKII8/30FDA | |||||
3 | RX.014ACCULINKII7-10/40FDA | |||||
4 | RX.014ACCULINKII6-8/40CE | |||||
5 | RX.014ACCULINKII6-8/40CE | |||||
6 | RX.014ACCULINKII7-10/40CE | |||||
7 | RX.014ACCULINKII7-10/30FDA | |||||
8 | RX.014ACCULINKII7-10/30FDA | |||||
9 | RX.014ACCULINKII7-10/40FDA | |||||
10 | RX.014ACCULINKII7-10/40CE | |||||
11 | RX.014ACCULINKII9/30FDA | |||||
12 | RX.014ACCULINKII7-10/40FDA | |||||
13 | RX.014ACCULINKII7-10/40CE | |||||
14 | RX.014ACCULINKII6-8/30FDA | |||||
Sheet1 |
I am looking to extract only the numbers in the last portion of the data in these fields.
for example, in (A2) RX .014 ACCULINK II 8/30 FDA I really only need the 8/30. I could always go with the simple =right(A2,8). However, looking at the multiple variations in this column, I really want to find out if there is a more complex formula to extract only the numbers. For example if I could get the 8 in one column and the 30 in another, as one is diameter and one is length.
But I'd be happy with being able to extract only the 8/30 because I can always do a text to columns based off the / later.
Please help if you can.
Thanks