LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 93
Default Reorder String

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
reorder data ellebelle Excel Worksheet Functions 0 June 19th 07 10:00 AM
Reorder columns? Arinté Excel Discussion (Misc queries) 0 October 24th 06 06:33 PM
Alphabetically reorder a text string with multiple words Mike S Excel Worksheet Functions 4 October 28th 05 07:21 PM
Alphabetically reorder a text string with multiple words Grandslam90 Excel Worksheet Functions 1 October 28th 05 06:30 PM
reorder function cb chiam Excel Worksheet Functions 0 August 2nd 05 11:28 PM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"