View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tatsujin Tatsujin is offline
external usenet poster
 
Posts: 25
Default Insert into presorted list

I have these variables:

sSorted = "ant, dog, giraffe, rhino, wolf, zebra"
sMixed = "pig, snake, coyote"

I want to build this newly sorted list:

aSort2 = "ant, coyote, dog, giraffe, pig, rhino, snake, wolf, zebra"

What would be some quick ways to merge both lists in a sorted manner?

Thanks!