How do you simply make every concatenation possible with multiple rows and columns in excel?
excel cc.PNG
This would help a lot. Thanks
How do you simply make every concatenation possible with multiple rows and columns in excel?
excel cc.PNG
This would help a lot. Thanks
e1=b1&c1&d1
and drag down
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There's a workbook that does this with two methods, one using formulas and one with VBA, at https://www.box.com/s/47b28f19d794b25511be.
Entia non sunt multiplicanda sine necessitate
Thanks a lot shg, thats pretty close to what Im looking for. Ive got to learn VBA
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks