Strangely, it looks like the data in A1 has both a leading blank spot and a trailing blank spot. This formula will show if they are exact, minus the blank spots:
![]()
=EXACT(LEFT(RIGHT(A1,LEN(A1)-1),LEN(A1)-2),A2)
Strangely, it looks like the data in A1 has both a leading blank spot and a trailing blank spot. This formula will show if they are exact, minus the blank spots:
![]()
=EXACT(LEFT(RIGHT(A1,LEN(A1)-1),LEN(A1)-2),A2)
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks