Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 9 of 9

Thread: Excel Question

  1. #1
    Senior Member AK Web Design's Avatar
    Join Date
    Dec 2010
    Posts
    123
    Member #
    25807
    Liked
    2 times
    I need to add a word to the end of multiple cells in excel. It's not every cell. Is there a simple way to do this? P
    New Jersey Website Design: We offer services in Web Design, SEO, Website Design, Belmar Web Design
    We are located in Belmar, New Jersey and Collingswood, New Jersey
    www.AKonlinedesign.com

  2.  

  3. #2
    WDF Staff AlphaMare's Avatar
    Join Date
    Oct 2009
    Location
    Montreal, Canada
    Posts
    4,570
    Member #
    20277
    Liked
    878 times
    What version of Excel are you using, is the current data in the cells the same in all of them or different, how many cells are involved - please be more specific.
    Good design should never say "Look at me!"
    It should say "Look at this." ~ David Craib


    http://digitalinsite.ca ~ my current site . . info@digitalinsite.ca ~ my email

    If you feel that someone's post helped you fix your problem, answered your question, or just made you feel better, feel free to "Like" their post. The "Like" link is at the bottom right of each post, along side the "reply" link. And if you are being helped here, try to help someone else - pass it on!

  4. #3
    Senior Member AK Web Design's Avatar
    Join Date
    Dec 2010
    Posts
    123
    Member #
    25807
    Liked
    2 times
    Excel 2007. Data is all different. The number of cells varies because I have to put different end words on different groups of cells.
    New Jersey Website Design: We offer services in Web Design, SEO, Website Design, Belmar Web Design
    We are located in Belmar, New Jersey and Collingswood, New Jersey
    www.AKonlinedesign.com

  5. #4
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,485
    Member #
    425
    Liked
    2783 times
    You could use ASP or .NET and connect using the Excel connection string to open up your spreadsheet, then apply your changes from there.
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)

  6. #5
    WDF Staff Wired's Avatar
    Join Date
    Apr 2003
    Posts
    7,656
    Member #
    1234
    Liked
    137 times
    Depending on the logic, I usually find it easier to copy the column into notepad, find and replace, and then paste back.
    The Rules
    Was another WDF member's post helpful? Click the like button below the post.

    Admin at houseofhelp.com

  7. #6
    Senior Member AK Web Design's Avatar
    Join Date
    Dec 2010
    Posts
    123
    Member #
    25807
    Liked
    2 times
    Thanks guys. I ended up taking Wired's advice. Worked pretty well. Thanks again.
    New Jersey Website Design: We offer services in Web Design, SEO, Website Design, Belmar Web Design
    We are located in Belmar, New Jersey and Collingswood, New Jersey
    www.AKonlinedesign.com

  8. #7
    Senior Member AK Web Design's Avatar
    Join Date
    Dec 2010
    Posts
    123
    Member #
    25807
    Liked
    2 times
    Not to dig up an old thread but I found an extremely easy way to accomplish this. Let's say you want to add the word "Apple" to multiple threads:

    1) Type "Apple" in cell B1
    2) Click on cell B1, then double click the small black square in the lower right corner of the cell. "Apple" should appear in all columns in column B
    3) Click on C1. Type =A1&B1
    4) Click on cell C1, then double click the small black square in the lower right corner of the cell. "Apple" should now be added to all cells in column A.


    Seeing that I had to to words to over 300,000 cells, this proved very helpful to me.
    New Jersey Website Design: We offer services in Web Design, SEO, Website Design, Belmar Web Design
    We are located in Belmar, New Jersey and Collingswood, New Jersey
    www.AKonlinedesign.com

  9. #8
    Junior Member
    Join Date
    Sep 2011
    Posts
    5
    Member #
    29444
    Liked
    1 times
    I'm glad you dug up the old thread, 'cause Wired suggested something I had never thought about doing before. Editing capacity in Excel generally sucks.

    Regarding what you suggested, AK, would that actually add the word "Apple" to all the cells in the column at the end of whatever is in those cells to start with, or would it replace? Replacing is easy, but the OP had a somewhat harder problem.

  10. #9
    Senior Member AK Web Design's Avatar
    Join Date
    Dec 2010
    Posts
    123
    Member #
    25807
    Liked
    2 times
    It added at the beginning.
    New Jersey Website Design: We offer services in Web Design, SEO, Website Design, Belmar Web Design
    We are located in Belmar, New Jersey and Collingswood, New Jersey
    www.AKonlinedesign.com


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 04:54 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com