How to concatenate columns row wise in excel file? -

i trying concatenate content of 2 different columns row wise not getting way can single formula/condition.

  name       surname              b     c          d     e          f     ............. 

and want display:

  b   c d   e f  ..... 

i know formula concatenate =concatenate(a1," ",b1). know can individual rows. there way can rows simultaneously single formula dependoing on number of rows?

i use macro that, macro works selected text, can change suit solution:

    sub append_text()     'add right text left text         each c in selection             if c.value <> "" c.offset(0,2).value = c.value & c.offset(0,1).value         next     end sub   

you select left side values , run macro, idea assign shortcut macro speed process.
let me know if work you.