Delete ALL text to the left of a specific character in MS excel

This is a matter of choice. I want to delete all text (all characters) to the left of a specific character or characters in a string.

For instance:

Suppose I have a row in a helloall cell welco metostackoverflow

Now I want to delete all the characters that are on the left side of the "stack". means the result should be stackoverflow (stackoverflow only)

Thanks in advance for your support.

+6
source share
3 answers
=RIGHT(input,LEN(input)-FIND("stack",input)+1) 
+18
source

Another formula: = MID (input, 20.60)

Here, the 1st number is 20, because the "s" in "helloall welco metostackoverflowflow" is the 20th character on the left, given that each space is also a character. 2nd number (60 here) - any number greater than the number of characters in the desired text "stackoverflow". There are 13 characters in stackoverflow. Thus, in this formula, the second number can be any positive integer equal to or greater than 13.

0
source

Find a replacement and use a wildcard.

eg.

Find: * Stack Replace: Stack

The result will be "Stack Overflow"

0
source

Source: https://habr.com/ru/post/920419/


All Articles