To separate the two into two different columns, try......... Data
TextToColumns using / as the delimiter..........

Vaya con Dios,
Chuck, CABGx3




"Raj" wrote in message
...
Hello people how can i split a cell in half

A
1 Tom
2 dick/harry (break dick and harry)

Thanks
Raj