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

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/05 09:16:14
A1:white,A2:the color is whiteB1:red,B2:the color is red.怎么实现 Bn列中 the color is

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)