Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
[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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
left and right functions | Excel Worksheet Functions | |||
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 | |||
how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) |