=E9&E10&E11 or =e9&" "&E10&" "&E11&" and E12 is blank" if you want spaces and
or text between the cell contents
--
paul
remove nospam for email addy!



"osaka78" wrote:

Dear friends
i have a text in cell e9,e10,e11 and e12 is blank
then text in e13,e14 and e15 is blank
then text in e16 and e17 is blank ..ect

how can i create a macro to CONCATENATE all cells before the blanck cell in
one cell

regards