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
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
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!
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
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)
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
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
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
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.
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