Hi everyone, I would love so help with an expression. I have attached a spreadsheet which outlines the input, desired output, and an approach I am considering. Here is a summary of the issue (which is the same as what is in Excel too)
One approach I am thinking of is:
After applying the "+" delimiter to parse out the data to the following, add a formula to the data such that, if there is no space before the comma, the original string (e.g., "TCL") repeats itself with a space in between (following the same example, it becomes "TCL TCL").
If anyone could please provide some pointers with the expression I would really appreciate it. If you have another easier approach, I would love to hear it too. Thank you so much!!
Solved! Go to Solution.
@erinylai One way of doing this, not the prettiest side, did lots of Regex to re-arrange the input string to make the parse easy
Yes! There is a "Desired Output" tab in the Excel file I attached in the last response and it's as follows. Really appreciate your help!
Than you so much binuacs! Form some reason it seems that in the final result, one instance of the number did not get turned into a range. (i.e., "4" in the last row ---> JEWRT GG356_177 4). Do you by chance know why that might happen?
Thank you so much again for helping me.
