Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying multiple items (searching)
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching several items from one document to another | Excel Worksheet Functions | |||
Searching for different items | Excel Discussion (Misc queries) | |||
searching and copying | Excel Worksheet Functions | |||
Searching for mutiple items in txt files | Excel Programming | |||
Searching multiple files and copying text | Excel Programming |