Try this....

Highlight the required cells you want to split and DATA TEXT TO COLUMNS
NEXT then enter the parameter that you want to split by (colon, space, etc)
FINISH

"Chalky" wrote:

I am working in a spreadsheet where I frequently use the filter and sort
functions. I want to split one cell into two in one column, I don't want to
use two columns and merge the rest of the cells as this upsets the
filter/sort functions.