One way is to use Data Text to Columns

Select the column

Click Data Text to columns (Delimited)
Click Next
In step 2: Type a colon in the "Other:" box
Click Finish
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"ross" wrote in message
...
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