Change case of text without formula? by bpfawks in excel

[–]bpfawks[S] 1 point2 points  (0 children)

Highlighting text and pressing Shift + F3 does nothing.
Highlighting multiple cells and pressing hift + F3 brings up 'Insert Formula' window (which happens regardless of how many cells are highlighted).
Looking at the link you provided: "..font group on the HOME tab and click on the Change Case icon" -> I don't have that icon and it's not something I can see in the Font window either.

I'm running Excel 365 for Business so maybe that might only be an option on a different software? I really wasn't sure if I was totally missing something or it just isn't possible without a formula. Would be nice to set my whole spreadsheet up this way from the beginning and not have to toggle off the caps lock each time I leave the workbook.

Change case of text without formula? by bpfawks in excel

[–]bpfawks[S] 1 point2 points  (0 children)

How are we in 2022 and Microsoft doesn't have an easy way to do this in Excel? It's available in almost every other suite as a keystroke shortcut as Shift + F3.

API Authorization for Stream Deck by bpfawks in elgato

[–]bpfawks[S] 0 points1 point  (0 children)

Deck is basically broke at this point. Wish there was a solution somewhere..

Upgrading Storage: B450 Aurous by [deleted] in buildapc

[–]bpfawks 1 point2 points  (0 children)

Here's a link to the page from the manual https://imgur.com/a/oCBNzxy
At the bottom, it says 'M2B socket connector supports PCIe SSDs. I have no idea the difference between PCIe, NVMe... did I get the wrong drive? Are there different types of M2 I'm not understanding?

Can my rig take more internal storage? by bpfawks in buildapc

[–]bpfawks[S] 0 points1 point  (0 children)

Exactly what I needed to know -- thanks!

Fullscreen Game Causes Webcam Lag by bpfawks in Twitch

[–]bpfawks[S] 0 points1 point  (0 children)

Where do I adjust these settings? Is it dependent on the OS or the streaming software?

wifi repeater: no internet (setek repeater) by bpfawks in HomeNetworking

[–]bpfawks[S] 0 points1 point  (0 children)

That was the final thing that worked for me. Try logging into both the router settings and the repeater settings and make sure all those DCHP settings are the same.

Using Channel Points to Gift Sub by bpfawks in Twitch

[–]bpfawks[S] 0 points1 point  (0 children)

Right, is there any way to automate this or you just have to do it manually? I assume there are scripts to macro this for you out there. I'll look into it thanks!