Try this:
=IF(RIGHT(A1,2)="DB",-1,1)*TRIM(LEFT(A1,LEN(A1)-2))
with your entry in A1.
Hope this helps.
Pete
Try this:
=IF(RIGHT(A1,2)="DB",-1,1)*TRIM(LEFT(A1,LEN(A1)-2))
with your entry in A1.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks