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
Printable View
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
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.
Excel 2007. Data is all different. The number of cells varies because I have to put different end words on different groups of cells.
You could use ASP or .NET and connect using the Excel connection string to open up your spreadsheet, then apply your changes from there.
Depending on the logic, I usually find it easier to copy the column into notepad, find and replace, and then paste back.
Thanks guys. I ended up taking Wired's advice. Worked pretty well. Thanks again.
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.
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.