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

R

ross

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
 
M

Max

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
 
Top