Pick out numbers/characters from cell

Closed
aehartle - Feb 19, 2010 at 10:11 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 19, 2010 at 02:39 PM
Hello,
I am wanting to pull information from a list like below. What i want is in one cell if it says 4/3lb i want it to say 12..(3*4) lbs. But in another cell i want to find the size example "lb" from the same cell..PLEASE help!!
thank you in advance

48 CT CASE
10/48/CASE
.88 OZ BUNCH
1# EACH
7 LB CASE
300/BOX
1/5lb
5 LB CASE
CASE
11 LB CASE
4/3lb
6/3#bag/cs
CASE
8 LB CASE
20 LB CASE
8 LB CASE
96 3 oz CASE
CASE
CASE
4/1 GAL CASE
CASE
CASE
CASE
88 CT CASE
CASE
6/#10/CASE
CASE
88 CT CASE
100 CT CASE
113 CT CASE
88 CT CASE
2 5 LB CASE
6/#10 Cans/Case
6/#10 CAN PER CASE

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 19, 2010 at 02:39 PM
I think I understand what you want. But if you could use this sample data and manually create how you want the data to look like in excel book and post that excel book to a share site like https://authentification.site it would be far more easier to see how and what needs to be done,
0