Extract text from a text string
In excel Formula:
=TEXTBEFORE(TEXT,DELIMITER)
=TEXTAFTER(TEXT, DELIMITER)
=TEXTSPLIT(TEXT, DELIMITER)
BUT IN WPS EXCEL,, ??
In WPS Excel
fX = LEFT(TEXT, END INDEX)
fX = RIGHT(TEXT, NO OF CHARS)
fX = MID(TEXT, START INDEX, NO OF CHARS)
THANKS FOR WATCHING...