Excel单元格中怎么批量将两行合并成一行

a（A1）

b（A2）

c（A3）

d

e

f

 

空白处输入

A1 A2（B1 C1）

A3 A4

A5 A6

ctrl+H将A全部替换为=A

就能实现两行变为一行

 

https://m.baidu.com/video/page?pd=video_page&nid=10947221543467505333&sign=55835667131710902&word=%E5%A4%9A%E4%B8%AA%E4%B8%A4%E8%A1%8C%E7%9A%84%E5%86%85%E5%AE%B9%E5%90%88%E5%B9%B6&oword=%E5%A4%9A%E4%B8%AA%E4%B8%A4%E8%A1%8C%E7%9A%84%E5%86%85%E5%AE%B9%E5%90%88%E5%B9%B6&atn=index&frsrcid=48304&ext=%7B%22jsy%22%3A1%7D&top=%7B%22sfhs%22%3A1%2C%22_hold%22%3A2%7D&sl=4&fr0=A&fr1=A&ms=1&lid=9783631734568010750&referlid=9783631734568010750&frorder=3&_t=1669537963161

原视频↑