Given your revised requirements (that there are lots of spaces between the
titles), it shouldn't be too difficult to split up your cell properly. You also
need to address the #Value error you are getting. It must mean you are not
copying the formula properly. So let's keep it simple and deal with one at a
time. First, try to pick off the left-most development need, by looking for the
first occurrence of two spaces together. Try:

=left(a1,find(" ",a1)-1)

Note there are two spaces between the quotes.

If this works, post back and we can show you how to pick off the rest, or work
with the formulas Ron has given you, replacing Char(10) with " ".

--
Regards,
Fred


"Danny boy" wrote in message
...
Hi Ron,

Thanks for your quick response. We are not allowed at work to download
programs onto our machines.

To confirm the three (sometimes more, sometimes less) development needs are
all within one cell howver for some reason they have loads of pspaces between
each one for example:

health and safety management fire training

instead of just being:

health and safety management fire training

I copied and pasted your formulas but i received a '#VALUE!' message when i
pressed Enter. The only way i can think of doing this is to enter a comma or
other symbol manually after each development need but as stated earlier i
have many rows of data.

I'm so fed up with this problem, if you could help further Ron i'd be very
grateful.

regards