Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses