krjoshi,
Give this formula a try:
=TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",99)),SEARCH("mws",SUBSTITUTE(A1,".",REPT(" ",99)))+99,99))
krjoshi,
Give this formula a try:
=TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",99)),SEARCH("mws",SUBSTITUTE(A1,".",REPT(" ",99)))+99,99))
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks