COC-Sample.xls

<div>
I see. &nbsp;This will definitely work for this one. &nbsp;What I was actually hoping for is a macro that I could just run as needed. &nbsp;In this case, the workflow might be.<br />
<br />
1. Run the &quot;Append to The Beginning of Selected Cells&quot; macro<br />
2. Type the text to append (i.e. Accounts::::) and press ok<br />
<br />
This would be a big help in the future. &nbsp;Thank you for anything you can do.<br />
Note also that there are generally at least 15000 records in most of the sheets.
</div>


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.

<div>
Also paste special appears to be greyed out in Excel 2010 that I have at work. <br />
<br />
Ugh, getting closer
</div>


Also paste special appears to be greyed out in Excel 2010 that I have at work.

Ugh, getting closer

<div>
<div class="content wysiwyg-content">
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. &nbsp;I need to fill that all the way down the column so that Accounts:::: appears before every company name with no space in between. &nbsp;Assistance is greatly appreciated.<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/02_w08/898664/COC-Sample.xls" target="_blank" class="file-inline" title="Append Accounts:::: to each Company Name (31 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>COC-Sample.xls</a>
</div>
</div>


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.

Append to Company Names

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.