I need to split some data in a cell to the right of a separator, which is a
colon.
eg: "CONSUMABLE:HPC92298X"
Would someone be able to point me in the right direction..
many thanks, Ross