Try highlighting the column, then doing Data Text to columns Delimited
and using / as the delimiter, and then highlighting the column after the
slash and choosing "do not import this column"

Just be sure you back up your data first and have a couple empty columns to
the right of your data column.......then Finish

Vaya con Dios,
Chuck, CAGEx3


"Kim" wrote in message
...
Hi all,

I have a list of colours in a column that look like the following examples

LIGHT BLUE/GREY
BLUE/GREY
CHERRY RED/BLACK
SILVER
LIGHT GREY

They represent vehicle exterior colours and after the "/" this is the
interior colour. As you can see some have the interior after the slash and
some don't have the interior colour but have two words for the exterior.
I
need to extract the exterior colour only as the following.

LIGHT BLUE
BLUE
CHERRY RED
SILVER
LIGHT GREY

I have tried the "find" and the "substitute" formula's but can't manage to
get it right.

Please help

Thank you