excel - CONCATENATE function for two columns -

so have 2 columns in excel, , b. column has letters - j, , column b has number 1 - 9. write concatenate function string each letter in column number in column b. it's going a1, a2, ...a9, , @ b1, b2, ... b9. there anyway me put in macro?

i assume this: dim rnga range dim rngb range

but don't know should next. thank help.

no macro necessary. assuming data in cell a1 , b1, place formula

=a1&b1 

into desired cell wish have concatenated result be. can dragged down using lower right hand corner of cell assuming entirety of columns concatenated.