I am creating a database. I have all the Product names in cells A2:A577. I am looking to do a mass find and replace. In my master template I put a Open parenthesis "(" where I need the product name to go.

Example

Replace "(" in Row 2 with Name in A2
Replace "(" in Row 3 with Name in A3
Replace "(" in Row 4 with Name in A4
and so on through 577 rows

I would like to do this with out having to go row by row, is there a way to do it all at once?