（练习）文本合并和引用

重复那贴已删除

乱是乱了点，想办法找到一个突破口。

来个超长工式，其实我对我这个公式很无语的。。。。。。
A8:=IF(COLUMN()=1,MID(SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","",3),1,FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",4))-1),MID(SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",COLUMN()+2),FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",COLUMN()+2))+1,FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",COLUMN()+3))-FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",COLUMN()+2))))



@1220小龙 :


=IF(COLUMN()=1,MID(SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","",3),1,FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",4))-1),MID(SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",COLUMN()+2),FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",COLUMN()+2))+1,FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",COLUMN()+3))-FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"","$",COLUMN()+2))))

@1220小龙
=IF(COLUMN()=1,MID(SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"
","",3),1,FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"
","$",4))-1),MID(SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"
","$",COLUMN()+2),FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"
","$",COLUMN()+2))+1,FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"
","$",COLUMN()+3))-FIND("$",SUBSTITUTE(SUBSTITUTE(INDIRECT(CHAR(64+ROW()-7)&1),"，",),"
","$",COLUMN()+2))))
这样应该就可以了

提一个和此题不关的建议，针对有需要解答的题目是否可以上传EXCEL表格，这样的话，大家在帮忙解题的同时还需要先打一遍题目~~

你的题可真多！
A9:
=SUBSTITUTE(MID(SUBSTITUTE(INDEX($1:$1,ROW(A2)),CHAR(10),REPT(" ",100)),FIND(A$8,SUBSTITUTE($A$1,CHAR(10),REPT(" ",100))),ABS(SUMPRODUCT(FIND(A$8:B$8,SUBSTITUTE($A$1,CHAR(10),REPT(" ",100)))*{-1,1})))," ",)

@轻舟上逆　吧主厉害，学习了，不过在单位中的"，"号未处理，加个SUBSTITUTE
=SUBSTITUTE(SUBSTITUTE(MID(SUBSTITUTE(INDEX($1:$1,ROW(A2)),CHAR(10),REPT(" ",100)),FIND(A$8,SUBSTITUTE($A$1,CHAR(10),REPT(" ",100))),ABS(SUMPRODUCT(FIND(A$8:B$8,SUBSTITUTE($A$1,CHAR(10),REPT(" ",100)))*{-1,1})))," ",),"，","")

吧主厉害！！！佩服

@
轻舟上逆 近日到吧主个人吧内看到您开的讲义贴，受益不小，深感吧主功力高深莫测。
您“老”见多识广，能否弄些题来让我等学子们操练操练，最好是能在每贴最后开布讲义。
个人所请，如吧主无暇可无视此请。晚辈拜谢！！！

我以前时间充裕,倍儿爱做题，都整出毛病了,一看见题就寸步难移，恐怕这也是EXCEL爱好者的通病。
你最近出的几道题简直是在煎熬我，思想斗争剧烈，点还是不点，我知道只要点开，我一准跑不了，最后忍不住还是点了两道，剩下的死活没敢看。
我现在时间紧，每天偷着来，怕老板看见，有几次被发现，我以请教问题为由搪塞，以至老板开始怀疑我的工作能力。
Ｅ网情深叹旧事
且把功夫做明天
开卷有Ｅ苦与乐
出题更比解题难

@
轻舟上逆
感谢吧主能在百忙中为我回复，叹你老板视力太过“势利”
网日情深空添愁，
多才多E高北斗。
诗词歌赋出口就，
E海浩翰泛轻舟。