Solved

Append to Company Names

Posted on 2015-02-16
3
60 Views
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.
COC-Sample.xls
0
Comment
Question by:frugalmule
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
Lucas Bishop earned 500 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
COC-Sample.xls
0
 

Author Comment

by:frugalmule
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.
0
 

Author Comment

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

Ugh, getting closer
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
excel pivot question 4 40
Vb.net dynamic formulas in runtime 11 62
ms office troubleshooting for users 8 36
nested if statement in excel help 4 15
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now