Hi Community,
I'm sure his is fairly simple, but I can't bend my head around it.
I have a cell that is filled with codes, up until a few days ago they were supplied in this format "A123_word word word"
I used the "_" to get the "A123" using
Worked well, but now the supplier isn't always using an underscore. So I need to expand that and search for an underscore or a " 5G" (including the space).
How can I amend this to accommodate?
The full formula is more in depth as below
I have tried (among other things)
Thanks in advance.
Bookmarks