FIND("-",B3,FIND("-",B3)+1) here is shown as FIND("-",KTE-Jan-359,4+1): The Find function finds the position of character "-" starting from the 5th character in KTE-Jan-359.
Note: As the first character "-" is in the 4th position of the text string, you need to add 1 to 4 in order to extract texts after it, and finally we end of with 4+1=5.
FIND("-",B3) + 1: The FIND function returns the starting position of character “-” in the text string KTE-Jan-359.
Note: As the first character “-” is in the 4th position of the text string, you need to subtract 1 to exclude it from extracting.
LEFT(B3,4-1): The LEFT function extracts 3 characters (4-1=3) from the left side of the text string KTE-Jan-359.
FIND("-",B3): The FIND function returns the starting position of character “-” in the text string KTE-Jan-359.
Tips: If you only want to split the text string into two parts based on a specific character, after splitting the first part with the above LEFT formula, you can apply the below RIGHT formula to extract the second part as the below screenshot shown. Now text string in each cell of column B have been split into three parts. Select a blank cell such as E3 to output the result. Select the result cell, drag the Fill Handle down to apply the formula to other cells. Enter the below formula into it and press the Enter key. Select a blank cell such as D3 to output the result.Ģ. Secondly, split the middle text string based on specific characterġ. And then drag the cell with your LEFT formula all the way down to apply it to other cells. Select a blank cell to output the result. How to use these formulas? Firstly, split the first text string based on specific characterġ. Text_string: The text string that you want to split text from Ĭhar: The character you will split text based on.
0 kommentar(er)
