ExcelBanter - Split Cell into the cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Split Cell into the cell (https://www.excelbanter.com/excel-discussion-misc-queries/39635-split-cell-into-cell.html)

Raj

Split Cell into the cell

Hello people how can i split a cell in half

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

Thanks
Raj

CLR

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

All times are GMT +1. The time now is 08:31 PM.