Hi
in excel, i have a text in one cell as below.
(1) ABCDE, (2)FQHIJ, (3)KLMNO, (4)PRQS, (5)TUVWXYZ
i want the result as below
ABCDE
FQHIJ
KLMNO
PRQS
TUVWXYZ
it seems the formula is to look for the text between "(1)" and the comma ","by using LEFT, MID, FIND. Other cell is text between ""(2)" and the comma and so on.
But i am still not clear about the formula exactly.
thanks a lot.
Bookmarks