View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
john john is offline
external usenet poster
 
Posts: 4
Default combine two row in one

I have two lines of data
Hello

I mast combine 2 rows with a macro vba and
create a third row with the data in increasing order, and delete the equal elements

example

row 1

E100001 E200120 E200124 E200127 E200152

Rows 2

E100001 E100101 E200120 E200124 E200127 E260250



Result in row 3

E100001 E100101 E200120 E200124 E200127 E200152 E260250

thanks
John