Find words starting with capital letters



I have a column (Species) where I have some species names e.g. Pseudomonas uno, Bacillus due, Vibrio tre - in the same cell. I want to create another column where I only have the info of the words with capital letter (Genus) filtered i.e. Pseudomonas, Bacillus, Vibrio. Right now I have a formula that allows me to get the first one = =IF(FIND(" ", Species@row) > 0, LEFT(Species@row, FIND(" ", Species@row) - 1)). Is there a way to filter by capital letters to get also the other three words in my new column?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!