Hello,
I am using Microsoft 365 Apps for Enterprise

I have a table with 2 columns: Fruit and Quantity. The "Fruit" column is unique.
For example:
Fruit Quantity
Orange 10
Apple 2
Melon 13
Banana 5

I have a cell that has the fruit names separated by a "-".
I need to return back the quantity for each fruit either all in 1 cell separated by a delimiter or one quantity per column. Whichever is easier.
Unfortunately, I cannot use VBA.

For example:
A1=
-Melon-Apple-Orange-

Return values:
B1=13;2;10; (let say the delimiter is ; )
OR
B1=13
B2=2
B3=10

If the cell has only 1 fruit, I can easily use vlookup to return back the quantity for that fruit.
Problem is the cell has multiple fruits separated by a "-".
Since I cannot use VBA, how do I extract each fruit name and do the search repeatedly?

Please help.