You can use a helper column:

C1: =A1 & B1

copying down as far as necessary. To do it in place, take a look he

http://www.mcgimpsey.com/excel/subs/mergedata.html



In article ,
"SheE" wrote: