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
Bookmarks