Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I tried to re-process strings in a VBA script that parsed some cells to no
avail. So I am looking for a function that will do so. Essentially the VBA created concatenations on nested data so I ended up with the following as the content of any SINGLE Cell (i.e. the | does not mean 'Next Field' it is a character) Value A Value A | Value B Value A | Value B | Value C Value A | Value B | Value C | Value D That is correct except when the value is Level AnyNumber, then I want to swap that with the prior value so Value A Level 1 | Value A Level 1 | Value A | Value C Level 1 | Value A | Value C | Value D I suppose in some cases it might be Value A Value A | Value B Value A | Level 1 | Value B Value A | Level 1 | Value B | Value D But the point is still the same Find Level X | * Swap for * | Level X Is that do-able? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
reorder data | Excel Worksheet Functions | |||
Reorder columns? | Excel Discussion (Misc queries) | |||
Alphabetically reorder a text string with multiple words | Excel Worksheet Functions | |||
Alphabetically reorder a text string with multiple words | Excel Worksheet Functions | |||
reorder function | Excel Worksheet Functions |