Append to Company Names

Posted on 2015-02-16
Medium Priority
Last Modified: 2015-02-17
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.
Question by:frugalmule
  • 2
LVL 19

Accepted Solution

Lucas Bishop earned 2000 total points
ID: 40613585
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

Author Comment

ID: 40614482
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.

Author Comment

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

Ugh, getting closer

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question