Link to home
Start Free TrialLog in
Avatar of Jase Alexander
Jase AlexanderFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel Converting a text entered sum into value with multiple entry criteria

Hi Experts

Hope you can help

We ahve packing lists sent from our suppliers to check for carton compliance; data that is entered into Column H on the atatached example. This entry is normally entered as dimensions LxWxH and, for example, looks either as 50*30*20 or 50x30x20

In order to check conformity, I would like to put a formula in Column K to sum the carton dimesions entry however it is normally in text and as you can see above, either separated by a * or an x

Ive tried using VALUE and ISNUMBER with a combination of extracting the values to sum the entries (that I will then look up to the correct available sizes) but to now, I cannot find a suitable solution

I have attached an example

Any help would be greatly appreciated

J
EE_Example.xlsx
SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jase Alexander

ASKER

Wow guys

Thank you so much for your help and these invaluable options

Cant thank you enough

Jase
Happy to help.