The new functions in #Excel are useful. The "old" formula to get the last name:
=MID(B5,FIND("*",SUBSTITUTE(B5," ","*",LEN(B5)-LEN(SUBSTITUTE(B5," ","")))) 1,100)
The "new" formula: =TEXTAFTER(B5," ",-1)
We like the second option :)
The cool thing in the example is the *negative* instance number in TEXTAFTER. This tells TEXTAFTER to get all text after the *last* space. Excellent feature, useful in many situations.
Bottom line: at over 2000 words, this article is mostly just AI-generated fluff. Yet, for some reason, Google is ranking it #1. Please do better Google! There are many great Excel sites out there. More words <> more quality. cc @JohnMu
Plus, you can also use macros to automate the process! Yes. But do be careful if you go this route, because "macros can be risky". Actually, there is no code or instructions, so most people probably won't try macros?
Another fluffy AI-generated article from @ZebraBI, currently ranking #1 as the "featured snippet" for "Excel weighted average" on @Google. (The screenshot comes from Exceljet, but that's for another day)
Conclusion: Good AI gen effort! But this article is crappy and shouldn't be anywhere near page 1 on @Google. Real humans will waste time trying to sort it out, assuming it's the "best" result available.