删除MS excel中特定字符左侧的所有文本 [英] Delete ALL text to the left of a particular character in MS excel

问题描述

这是一个与excel相关的问题。我想删除特定字符左边的所有文字（所有字符）或字符串中的字符。

例如： helloall welco metostackoverflow

现在我要删除堆栈左侧的所有字符。
表示结果应该是 stackoverflow （只有stackoverflow）

提前感谢您的支持。

解决方案

  = RIGHT（输入，LEN（输入）-FIND（堆栈，输入）+1）
  

This is an excel related question. I want to delete all text (all characters) to the left of a particular character or characters in the string.

For instance:

suppose I have an string in a cell helloall welco metostackoverflow

now I want delete all the characters which are at the left side of "stack". means result should be stackoverflow (only stackoverflow)

Thanks in advance for your support.

解决方案

=RIGHT(input,LEN(input)-FIND("stack",input)+1)

这篇关于删除MS excel中特定字符左侧的所有文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！