Parse text with different variables

[Calicarrie]

I am trying to parse some text values into 2 cells based on the "Name" and the "Size". Examples include:

PORT750ml/4pk
CHARDONNAY3L/o
WINE1.5L

Which would read as (separate cells):
PORT 750ml/4pk
CHARDONNAY 3L/o
WINE 1.5L

Since the "size" is variable and the "name" is not of consistent length, I am not sure how to automate this (preferably without a macro). I tried a "Left" function with "find" but the find function cannot include wildcards and the size is not standard.

Any ideas would be greatly appreciated!

Thanks!

 

[Scott Huish]

From this workaround, I am to believe that there is no direct way to say, "Search/Find the first position of any of the following values within a string"?

No, there isn't, you could write a UDF that could do it, but with a native formula, no. The way I did it is typically the way it's done.

 

[Desu Nota from Columbus]

Thank you for taking the time to help a noob like me understand this.

 

[Calicarrie]

Wow! I don't think I would have ever gotten there. Thank you so much...it works beautifully!