I am looking to extract a specific value from the below
John Harold Smith WR10472285
I need to capture the first name (John), surname (Smith) and wrnumber.
However there are and will be times where there wont be a middle name to capture.
My current code only works when there is no middle name, therefore i can’t use that code.
can anyone help me with this?