Using find() in Excel to remove text from string

Solution 1:

Use SUBSTITUTE.

=SUBSTITUTE(A2,"Application: ","")

Solution 2:

Actually, I think that the simplest way is to use the Find & Replace on the column concerned if you intend to delete the original later on.

1. Hit Ctrl+H.

2. Find Application: ("Application", colon, space) Replace by nothing

3. In the Find & Replace window, click on Options >> and make sure that the 'Within: ' is set to "Sheet" and that 'Match entire cell contents' is unchecked.

Otherwise, another function besides SUBSTITUTE() you can use is MID():

=MID(text, start, length)

In your case, you can use:

=MID(A2, 14, LEN(A2))

Which will take everything from the character position 14 (After all the characters in "Application: ") to the end of the text. LEN(A2) is actually larger than the text you want, but that doesn't matter, it means it'll take everything till the end.