How to separate text in excel

In this video I show you many different ways to search text in excel. There are six main formulas to use to separate text and they are LEFT, RIGHT, MID, SEARCH, FIND & LEN and these can be used in different combinations depending on what you want to find.

These are the formulas I use in the video.

=LEFT(B5,FIND("-",B5)-1)

=MID(B5,SEARCH("/",B5)-2,10)

=MID(B5,SEARCH("-R",B5)+1,5)

=IF(ISNUMBER(SEARCH("through-Ascarite",B5)),"through-Ascarite","not found ")

=RIGHT(B20,LEN(B20)-FIND("F",B20)-1)

=MID(B21,FIND("F",B21)+2,2)

=MID(B20,FIND("F",B20)+4,2)

=EXACT(F8,F9)

The next two formulas produce the same result. I didn’t show the second formula in the video as it is longer but it may be easier to understand.

=MID(B20,FIND("L",B20)+1,FIND("-",B20,FIND("L",B20)+1)-1-FIND("L",B20))

=LEFT((RIGHT(B20,LEN(B20)-FIND("F",B20)-1)),FIND("-",(RIGHT(B20,LEN(B20)-FIND("F",B20)-1)))-1)

---------------------------------------------------------------------------------
#exceltutorials #excelformulas #exceltipsandtricks

VIDEO INFO: These data are related to my PhD research.
---------------------------------------------------------------------------------
IF YOU LIKE THIS VIDEO YOU MAY ALSO LIKE: