Jan 12 2023 08:22 AM
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 name in a given cell using the first 4 letters of the genus and combined with the first 3 letters of the species. For example, cell A1 is "Festuca campestris" and I would like cell B1 to result in "FESTCAM". I've looked online and get stumped by the complexity of nested functions using textjoin. Any help would be appreciated
Jan 12 2023 08:34 AM
Solution=UPPER(LEFT(A1,4)&MID(A1,FIND(" ",A1)+1,3))
You can try this formula which seems to work in my sheet.
Jan 12 2023 08:47 AM
Jan 12 2023 08:34 AM
Solution=UPPER(LEFT(A1,4)&MID(A1,FIND(" ",A1)+1,3))
You can try this formula which seems to work in my sheet.