![]() ![]() ![]() For instance, to get the text after the word 'color', use this formula: TEXTAFTER (A2, 'color ') Please note that the delimiter includes a space after the word 'color ' to avoid leading spaces in the results. "+"&"Excel +addin": And then use the & operator to concatenate a plus sign before the first word and returns the result as +Excel +addin. So, to copy text after a specific word into another cell, specify the word as the delimiter. SUBSTITUTE(B3, " "," +"): The SUBSTITUTE function replaces a space within text string "Excel addin" with " +". If the text string In B5 are separated by other specific character, such as comma, dash, etc., you need to change the second argument in the SUBSTITUTE function to the corresponding character. In this formula, "+" is the character you will add before each word in B5. And then drag the cell with this formula all the way down to apply it to other cells. Enter the below formula into it and press the Enter key to get the result. Select a blank cell to output the result. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |