Formula
=LEFT(A1,FIND("^",SUBSTITUTE(A1,"/","^",4)))
![]()
[a1] = left([a1],instr(replace([a1],"/","^",1,3),"/"))
Formula
=LEFT(A1,FIND("^",SUBSTITUTE(A1,"/","^",4)))
![]()
[a1] = left([a1],instr(replace([a1],"/","^",1,3),"/"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks