Or, you could use LEFT, MID and RIGHT functions, but you need to give
more explanation of what you want to achieve.

Pete

On Nov 30, 3:58 pm, Tim wrote:
Does anyone know how to split a cell in Microsoft Excel. I am convinced i
use to be able to do this i older versions of Microsoft but can't seem to be
able to do from XP?

Cheers