Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() [Excel 2003] I have a vlookup which populates cell $A$1 with codes separated by "-". For example: "A3-C-D4-F5" or "A-C-D5" or even "C" I would like these to be processed so that on the rows below $A$1, the idividual items are separated out line by line, such that A3-C-D4-F5 would be listed as A3 C D4 F5 in the cells below. The codes have "-" in various positions (or none at all in the case of a single item) and can have up to 7 codes in a string. Sounds complicated.. Can anyone help me separate the individual items from a hyphenized list of codes as described above? Thanks, Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using LEN / LEFT / MID / FIND functions to create a list | Excel Discussion (Misc queries) | |||
Use of Find with Left, Mid, Right functions in nested IF(and('s | Excel Discussion (Misc queries) | |||
Where can I find list/table of functions/formulas | Excel Discussion (Misc queries) | |||
where do i find create list in Excel | Excel Worksheet Functions | |||
Create ListBox (?) same as Find all Result List | Excel Programming |