Thanks for your reply James. That doesn't really do the trick, maybe because
it is only one cell or maybe because I am trying to put a formula into the
cell I want to split.

Chalky

"James Hamilton" wrote:

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.