In column A cell contains values in the format: GL-A/123/1-data1,in column B value is PL1-B/143/1-data2,so on it follows the same format in column c and columnD.
在列A中,单元格包含以下格式的值:GL-A / 123/1-data1,在列B中,值为PL1-B / 143/1-data2,因此在列c和列D中遵循相同的格式。
I need it to be formated in such a way that, in Column E it should be: A/123/1-data1;B/143/1-data2
我需要以这样的方式形成它,在E列中它应该是:A / 123/1-data1; B / 143/1-data2
2 个解决方案
#1
2
A formula that will work, in E1 and copy down.:
一个可以工作的公式,在E1和副本中:
=CONCATENATE(MID(A1,FIND("-",A1)+1,LEN(A1)),";",MID(B1,FIND("-",B1)+1,LEN(B1)))
#2
1
=CONCATENATE(MID(A1,FIND("-",A1)+1,LEN(A1)),";",MID(B1,FIND("-",B1)+1,LEN(B1)))
#1
2
A formula that will work, in E1 and copy down.:
一个可以工作的公式,在E1和副本中:
=CONCATENATE(MID(A1,FIND("-",A1)+1,LEN(A1)),";",MID(B1,FIND("-",B1)+1,LEN(B1)))
#2
1
=CONCATENATE(MID(A1,FIND("-",A1)+1,LEN(A1)),";",MID(B1,FIND("-",B1)+1,LEN(B1)))