Dear MrExcel, I have a column "J" -that contains the following data e.g.
PB GRN11284 1582800-10-07/20
SL Core Quarantine
MO17-09 NCR1259 - Rejected sent to Quarantine
MO17-09 NCR1259 - Rejected sent to Quarantine
AD B20 1575700-01-01/20
It should be split into the next three Columns -...