sumproduct - sum the same abbreviated titles of medical journals

To extract the publication abbreviation we need a delimiting character, a unique character in the string found in column A that denotes where the publication name ends. In some instances theres a full stop (.), but not all; in some instances there's a space, but spaces actually within the publication name means we can't do this.
As I say, this isn't a big ask, but your data needs some serious tidying up.

OK, we can manually clean our data - add full stop (.) where needed.

How will then be the formula for column A and column B?