Mike_Alex
New member
Have a conundrum that am hoping to resolve without a very long written calc including a boat load of Finds, Lens, Rights, Lefts & Concats. Problem is that I have list of item groups that includes partial sets of numbers enclosed within forward slashes. Example would be (A123-45/56/67/78/B123-12) all in one cell. I want to create a cubeset out of this data, so I need the data to return as (A123-45) (A123-56) (A123-67) (A123-78) (B123-12), with each parenthesis being one cell each. Not all item groups have the same number of items, some have one (A123-12) where others may have more (like the aforementioned). Any chance you could think of a smaller formula than the one I am getting ready to start putting together? I am sure 8192 is not going to large enough for this one.