This function can be used if in case we need to extract the text starting from the right of the cell. Format= defining the format in which we need the text.TEXT= the location of the cell from where the Text has to be extracted.First, we need to know in which format we need to extract the text. Using this function, we can convert any value to text if we have a numeric value in a cell and we need that value as TEXT, then we can actually use this function. The text will be the cell from where the text has to be extracted. Num_chars will the character count that needs to be extracted. Now we need to use the below function of LEFT. If we need the characters from the left, then only we need to use this function. The first step will be to identify whether we need the characters from the left of the text or the right of the cell. In this way, the text is extracted only till the “Space”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |