Please try at journals 2018 B2 for extract the publication abbreviation and remove "."
=SUBSTITUTE(LEFT(A2,MIN(FIND({0,1,2,3,4}+{0;5},A2&1/17))-1),".","")
Please try at journals 2018 B2 for extract the publication abbreviation and remove "."
=SUBSTITUTE(LEFT(A2,MIN(FIND({0,1,2,3,4}+{0;5},A2&1/17))-1),".","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks