Chalky,

Try this, it may work depending on the data that you want to split...

A B
1 chalky =left (a1,2) will yield "ch" in cell B1

This returns the first two characters of A1. You can also use the
=right(....) function and I think there's another one.... "mid" perhaps.

Good luck


James


"Chalky" wrote:

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.