Another one, but slightly shorter =IF(COUNT(RIGHT(A2,11)),LEFT(A2,LEN(A2)-6),A2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks