Splitting Data in a cell, left or right of a separator.
 

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

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