Copy multiple excel cells into one
I have lots of Excel data, whereby there are many records which i need to consolidate into one cell.
I know that if I copy text with a carriage return character it will automatically go to new cells, AND that if you paste that same text into the formula bar, it paste's the records into that same cell, keeping the carriage return character, however I am wanting to copy multiple Excel cells then somehow paste them into a single cell.
I know I can paste into a text editor then paste using method above, however my intention is to get something really quick and effective.
Any suggestions?
链接地址: http://www.djcxy.com/p/62266.html下一篇: 将多个Excel单元复制到一个中