Hi,
See if this does what you need:
![]()
=LEFT(A1,MIN(FIND(".",A1),FIND("-",A1),FIND("/",A1))-1)
Hi,
See if this does what you need:
![]()
=LEFT(A1,MIN(FIND(".",A1),FIND("-",A1),FIND("/",A1))-1)
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks