Forum Discussion
Solved
creating and combining abbreviations from two words
I work with plants as part of my job and I handle databases of plant names, mostly in latin (ie. genus and species). I would like to be able to create a 7 letter capitalized abbreviation from a latin...
=UPPER(LEFT(A1,4)&MID(A1,FIND(" ",A1)+1,3))You can try this formula which seems to work in my sheet.
=UPPER(LEFT(A1,4)&MID(A1,FIND(" ",A1)+1,3))You can try this formula which seems to work in my sheet.