Append to Company Names

The Company Name column in the attached spreadsheet contains company names that need to be prefixed by the syntax Accounts:::: so that the Company Name Baylor University becomes Accounts::::Baylor University.  I need to fill that all the way down the column so that Accounts:::: appears before every company name with no space in between.  Assistance is greatly appreciated.
COC-Sample.xls
frugalmuleAsked:
Who is Participating?
 
Lucas BishopConnect With a Mentor Click TrackerCommented:
Updated xls attached. There's a second worksheet inserted which does a simple concatenation. Your workflow would be:

1.) Import all of your data into sheet 1
2.) In sheet 2, copy the formula (column a) down for however many rows exist in sheet 1
3.) Copy all data from column a in sheet 2
4.) Paste Special (data only) into column e of sheet 1
COC-Sample.xls
0
 
frugalmuleAuthor Commented:
I see.  This will definitely work for this one.  What I was actually hoping for is a macro that I could just run as needed.  In this case, the workflow might be.

1. Run the "Append to The Beginning of Selected Cells" macro
2. Type the text to append (i.e. Accounts::::) and press ok

This would be a big help in the future.  Thank you for anything you can do.
Note also that there are generally at least 15000 records in most of the sheets.
0
 
frugalmuleAuthor Commented:
Also paste special appears to be greyed out in Excel 2010 that I have at work.

Ugh, getting closer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.