what is the source data format (before loading into Excel)? Anyway, one way is: 1. export to txt format 2. re-import into excel, with the "|" as delimiter, so each number will take one cell BTW, this doesn't seem to be related to database...
【在 M*****r 的大作中提到】 : what is the source data format (before loading into Excel)? : Anyway, one way is: : 1. export to txt format : 2. re-import into excel, with the "|" as delimiter, so each number will take : one cell : BTW, this doesn't seem to be related to database...
M*r
4 楼
Not quite understand... But, can you use VBA?
【在 b******i 的大作中提到】 : 大哥这招我用过了,有几千几万个这样的单元格,用手就累死了…… : : take
B*g
5 楼
co - "bu dong". can not understand why thousands can not work.
【在 M*****r 的大作中提到】 : Not quite understand... : But, can you use VBA?