i am looking to extract some data from a cell in google sheet that contains multiple data, however i need to capture the data, manipulate it before entering the data elsewhere. please see below.
the main data i need to capture is the WR number, there will be times when there will be a space between the WR and number e.g. wr 5748365 but other times it will be wr5648493
can anyone help me with this?