Hi much beloved forum!
I am looking for a way to extract text from a single cell into several other cells. I am currently using find and mid functions but quickly realized that this is not going to work when the lenght of the text is changing. Is this even possible?
The only thing that is constant is the delimiting "/" and the values in between (5 values).
Example of series:
Which next time might look something like:
The ideal result would look something like when each cell has a single value:
90 in C1
10,20 in C2
56 in C3
4554 in C4
112,2 in C5
Any suggestions of how to construct the formula? Or do you have to have 5 separate formulas?