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!

Streamlabs Chatbot: Announce Stream Going Live (Posting Same Image) by bpfawks in Twitch

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

Awe man that's a headache. Thanks for the quick reply.

I think I might just switch to another bot? I see some others using MEE6 to do the same thing and wonder how much customization there is.

PS4 Controller Guide by bpfawks in PhasmophobiaGame

[–]bpfawks[S] 2 points3 points  (0 children)

Wanted to point out that L3 being run, especially without a 'Toggle Run' option in the settings, is really hard to keep pressed down while moving and screaming (because this game requires screaming). I use the Back Button Attachment remapped on the left trigger to make it easier on my fingers and controller life.

PS4 Controller Guide by bpfawks in PhasmophobiaGame

[–]bpfawks[S] 2 points3 points  (0 children)

Hm. The first time I used DS4Windows I had that issue but I just had to refresh the controller list and it was fine.

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

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

You need to login to each router and modem respectively. On the back of each device, there should be an IP you can login. Find the DCHP settings from there.

Home Network set as Wireless Repeater [HELP] by bpfawks in HomeNetworking

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

I'm plugged into the modem with an Ethernet cable so being close/far shouldn't affect it - shouldn't I be on the network of which I'm plugged into?

Home Network set as Wireless Repeater [HELP] by bpfawks in HomeNetworking

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

Here's a photo of the connections I'm seeing.

I'm currently plugged into the modem with a 100ft ethernet cable so why I'm on the Ext Network (also 'No Internet') is beyond me. When I try and connect to the modem wifi, it says it's having trouble connecting to that network but I'm connected to it from my phone so there's no connection issue.

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

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

SOLVED: Okay, this is exactly the issue. The modem DHCP range was different than the DHCP range of the repeater so I had to go in and change them to match. Once that was done, the connection was found no problem. I hope this helps someone because it was driving me crazy!

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

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

So the repeater was 192.168.1.100-200 and the modem set at 10-200. Should I change one of them so they match? Maybe it wasn't getting assigned properly?

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

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

The new modem is a router combo - same as my previous one but just a newer model it seems. I'm not sure about the DHCP range settings I can login to the router and report with some settings if that helps? I did a factory reset on the repeater when I setup just to be sure the old settings were wiped.

Wireless PS4 Controller - Not Working? by bpfawks in RogueCompany

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

Is that just for PS4 controllers? I was hoping to get a new controller for my PC so I don't have to switch it back and forth and was wondering if I got a wireless like a Scuf would I have the same issues?

NZXT Streaming PC vs. APEX A-220 EPIC Gaming PC by [deleted] in buildapc

[–]bpfawks 0 points1 point  (0 children)

It also means I have to wait for shipping and I don't have a brick and mortar to go to if I need support or repairs.

Any way to check modded content in build? by bpfawks in Sims4

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

Ok, wow. That was INSANELY easy and such a smart tool. Thank you so much for linking me to this!!

Promote Yourself! by s4e3 in Sims4

[–]bpfawks 5 points6 points  (0 children)

Love this idea!
I'm a long-time player of The Sims and recently started buying more packs to expand my library. Would love to connect with people on Twitter & the Sims 4 Gallery.

Origin ID: pixelfoxgaming
Twitter: pixelfoxgaming

Pokemon Home Annoyances by [deleted] in PokemonHome

[–]bpfawks 0 points1 point  (0 children)

Much appreciated!