[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 80
  • Last Modified:

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
0
frugalmule
Asked:
frugalmule
  • 2
1 Solution
 
Lucas BishopClick 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now