How do I copy multiple items in a cell to another?

Example:

In cell K-244 I have the following information -
AC-3 Access Enforcement, IA-3 Device Identification and Authentication,
SC-7 Boundary Protection, SC-11 Trusted Path

In cell J-244 I need the result -
AC-3, IA-3, SC-7, SC-11

Right now I'm using the formula =LEFT(K241,SEARCH(" ",K241,1))
but this only returns the first iteration. AC-3 in my example above.

Any suggestions are greatly appreciated.

Lizardoflife


--
lizardoflife
------------------------------------------------------------------------
lizardoflife's Profile: http://www.excelforum.com/member.php...o&userid=28881
View this thread: http://www.excelforum.com/showthread...hreadid=486309