Hi everyone,

Before i test the laws of gravity with my computer i thought i'd post here
first. I am hopelessley trying to split the contents of a single cell into
one (or more) columns. For example in A1 i have 3 'development needs':

health and safety
management
fire training

i need to split the contents of this cell so each development need transfers
into the adjacent cells, for example

health and safety stays in A1
management transfers to B1
fire training transfers to C1

i have tried texting to colums but i keep getting stuck as if i have space
as a common delimiter it breaks health and safety (for example) into 3
columns! I can't do fixed width either as i have around 1000 rows of data so
it may get messy.

Any takers for this? If i have to write code or something please be gentle
as i have no idea about excel, i usually use SPSS in my job so this is quite
new to me.

Thanks in advance!