I'm relatively new to concatenating in Excel (Office 2007) but have learned to do it.
In a very large spreadsheet with multiple columns and over 200,000 rows I need to concatenate repeatedly as I prepare the data to be moved to Word. I have 2 types of concatenate needs:
Type 1
Within the spreadsheet, I sometimes need to concatenate 2 cells. Other times 3, 4, or even 5+. Usually contingent cells in rows below.
For the many instances I need to concatenate 2 cells I learned to just copy that cell to the new location and the formula works perfectly for that cell too because the cells included change appropriately.
But when I need to concatenate 3 or 5 cells I need to recreate the concatenate folmula which I find time consuming and error prone.
Question: is there a trick to tell the formula "this time I want the next 2 cells. This time the next 3. Etc."? Dragging does not work for me because I want to add a space or a character between each added cell and the unmodified concatenate formula does not do this without modification.
Maybe a series of macros? (This is a large dataset......)
Type 2
Is it possible to concatenate cells from Excel spreadsheet A directly into a cell in Excel spreadsheet B?
I can obviously do the concatenation in one spreadsheet and copy the results into the other, but that is time consuming and error prone. Can it be done "directly"?
How?
Thanks you.
Bookmarks