basically![]()
=IF(ISERROR(FIND(" ",RIGHT(A2,11))),LEFT(A2,LEN(A2)-6),A2)
if right 11 characters has has spaces then take whatever is in "A"
otherwise use your left len formula
basically![]()
=IF(ISERROR(FIND(" ",RIGHT(A2,11))),LEFT(A2,LEN(A2)-6),A2)
if right 11 characters has has spaces then take whatever is in "A"
otherwise use your left len formula
Last edited by humdingaling; 07-25-2013 at 09:50 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks