Extract text before or after space with formula in Excel You can quickly extract the text before space from the list only by using formula. Depending on where you want to start an extraction use one of these formulas. The first name starts with the seventh character from the left W and ends at the twelfth character the second space.
To extract a substring containing specific text for example the symbol use SUBSTITUTE REPT MID FIND TRIM and MAX in Excel.
Select cell C16 and enter the formula FORMULATEXT F3. In the popping Extract Text dialog under the Extract by location tab the first three options support you to extract substring from left mid or. The gist of this formula is to replace a given delimiter with a large number of spaces using SUBSTITUTE and REPT then use the MID function to extract text related to the nth occurrence and the TRIM function to get. Excel LEFT and Right Function to Extract unknown length of Text from a String Just paste this formula in desired cells to extract the name from the text in excel.