Like this:
=LEFT(A1,5)=LEFT(B1,5) will return TRUE if the first 5 characters match and FALSE if they don't
Like this:
=LEFT(A1,5)=LEFT(B1,5) will return TRUE if the first 5 characters match and FALSE if they don't
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks