I have a cell in a Google Sheet that contains the result of 2 data inputs and it looks like this in the cell:
F11.20 OPIOID DEPENDENCE, UNCOMPLICATED Z79.891 LONG TERM (CURRENT) USE OF OPIATE ANALGESIC
I want to be able to extract F11.20 and Z79.891
I know if I use the SPLIT function in Formatter I can get these codes separated but knowing in which order the output occurs consistently is difficult because the input maybe different codes…
So is there another way to identify these codes F11.20 and Z79.891?
Thanks for the help