Please help me with Excel

**Panther35** · 06-17-2011, 06:27 PM

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?

**Jim28** · 06-17-2011, 06:51 PM

Can you post the spreadsheet for us to look at?

**martindwilson** · 06-17-2011, 07:29 PM

Please help me with Excel

please read forum rules and change your post title
rule 1

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

**teylyn** · 06-18-2011, 05:12 AM

@Jim28, please do not quote whole posts. It just slows down the page load.

@Panther35, Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST