This is actually a simple formula, but i just forgot it because it's a long time ago that i used it.
so i have a Sheet with like 500 rows contain
JVHSAKJHAB12-11 with date 12/08/2011
IKSH12 with date 11/06/2011
:
:
etc...
so, i remember i can erase the word after "with date" and before "with date" with "*"
i just forget where to put it and what's the formula?
Can you help me guys?
i know i can do it by replacing the "with date" with any symbol then separate them with Text to Column, but i just want to remember exactly how to do it by "*"
Thanks in advance guys.
Bookmarks