Suppose I have some Excel spreadsheet with the following column:
what A-12287 who
just A-7819 C-45556
As you can see - I have a text combined with some RegEx consists of A,B or C, hyphen and some number with up to 5-6 digits. Some of these expressions appear more than once in some lines.
I would like to parse this RegEx (which varies somewhat between lines) to another column. If there are multipile expressions in some line (like the 5th line in my example), then I would like to seperate them by any character which is not the hyphen (space would do it).
Is there any built-in function in Excel that can allow me to do so? Maybe some VBA script?
I found this thread, but I would like to see first whether I can do it without any external add-on or software. Does this specific add-in supports what I need?