Hey, we're famous for getting ripped off :) https://t.co/Mh1P5htvpw

On Bing, the same article is on page #3, FWIW.

See your instructions here:

Hey @ZebraBI - the @msexcel team will be surprised to learn that Excel has a STRIKETHROUGH() function! 😀 Currently #1 in Google for "Excel strikethrough". cc @MrExcel ,@LeilaGharani, @googlesearchc https://t.co/tXJQGg5tX1

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.

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 :)

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

Not helpful? Here are two more articles on the same topic:

What about advanced techniques?! They have it covered. Check out this word salad:

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?

Followed by some nonsense about creating a weighted average with multiple criteria. Seriously, give these 4 steps a try, and let us know how it goes!

Maybe the most interesting thing about this article is that there is not a single working formula or screenshot. The closest we get is this how-to:

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)

Yes, AI is cheap. But there are other costs...

@Google The article itself is here:

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.

What about the formulas? See below. Honestly, this is painful. For a start, the formulas don't agree with the screen. Next, the formulas above the screen just aren't gonna work. Something got lost in translation.

What about the guide itself? The first tip is to use the Text to Columns feature, repeated 2x for some reason, both times with different advice. Worse, some of the info is just wrong:

And so many words! About 2400 in all. AI is cheap, so let's ask for more words, starting with a 200-word styrofoam intro:

What else? Are there obvious AI attributes? Yes. First, note the giant TOC with 12(!) sections: