在删除文本时复制单元格内容的Excel公式 [英] Excel formula that copies cell content while removing text

问题描述

我需要一个公式，该公式将A1复制到B1，同时删除"-text3"(第二个破折号和其后的文本."text-text-text"格式在A列中保持一致). text1，text2和text3分别代表各种不一致的字符串.

I need a formula that will copy A1 to B1 while removing "-text3" (the second dash and the text that follows it. The "text-text-text" format is consistent in column A). The text1, text2 and text3 each represent a variety in inconsistent strings.

A1:  text1-text2-text3
B1:  text1-text2 (-text3 has been removed by the formula)

推荐答案

使用:

=LEFT(A1,FIND("}}}",SUBSTITUTE(A1,"-","}}}",2))-1)

这篇关于在删除文本时复制单元格内容的Excel公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！