A1:white,A2:the color is whiteB1:red,B2:the color is red.怎么实现 Bn列中 the color is "An"EXCEL 软件中

来源:学生作业帮助网 编辑:六六作业网 时间:2024/11/26 23:21:35
A1:white,A2:thecoloriswhiteB1:red,B2:thecolorisred.怎么实现Bn列中thecoloris"An"EXCEL软件中A1:white,A2:thecolo

A1:white,A2:the color is whiteB1:red,B2:the color is red.怎么实现 Bn列中 the color is "An"EXCEL 软件中
A1:white,A2:the color is white
B1:red,B2:the color is red.
怎么实现 Bn列中 the color is "An"
EXCEL 软件中

A1:white,A2:the color is whiteB1:red,B2:the color is red.怎么实现 Bn列中 the color is "An"EXCEL 软件中
用这个函数 fx = CONCATENATE("the color is 空格",An)