Excel XLOOKUP with Wildcards – Functionality Change

I’m playing with XLOOKUP with wildcards (Match_Mode 2). I believe it used to be if you want it to return results where a item in that excel it was = =XLOOKUP(""&"Text"&"",A:A,B:B,0,2), if it was only before =XLOOKUP("Text"&"*",A:A,B:B,0,2).

I’m finding now you can’t get just before nor just after and you don’t need "*"& just the star. =XLOOKUP("text*",A:A,B:B,0,2) The last comment is shown in red in the image.

Please take a look at the image below and provide thoughts

Thanks, Brad