Thanks guys . Both functions work . I will try to manage with them . I
prefered a macro that moves the concatenated results in a column as i
explained in first post for the following reason :

The cells i have to process from 2 columns are from something like A1B1 ,
A9B9 , A12B12 , A25B25 going to something like A10000B10000 ( without a clear
pattern that i have content every 10th cell , it's random ) . That's why i
needed the results to be one below another in same column ( say from C1 to
C100 )

If a macro can be done , many thanks in advance