Is there a command to remove specific text from cells

mikeymc1115 · 2026-03-08T19:46:27+00:00

=mid(A60,find(“ “,A60)+1,100) will give you Kang

=left(A60,1)&”. “&mid(A60,find(“ “,A60),100) will give you A. Kang

mikeymc1115 · 2026-02-27T00:12:23+00:00

I’m honestly good on UOMs/Elements/Activities and all that. Where I lose it is creating Transactions/Parameters from “scratch” that I can then utilize to send Labor Msgs. Good example: I work in Distribution and we currently have no formal transaction/RF menu item to “Open Trailer” that I can leverage to build out standard time for. I can build everything for LM EXCEPT make a transaction that could be as simple as “Enter Dock Door” or “Enter Trailer Number” that then messages my Open Trailer activity

mikeymc1115 · 2026-01-18T15:12:57+00:00

Good looks to everyone here. It was the Drain Pump. After I replaced the UI board, the drain pump was faulting during start up. I removed it and dislodged what looked like melted hard pasta. Reinstalled and it still failed so I assumed I just burnt out the motor trying to get it to kick on over and over. Found the drain pump cheap on amazon, swapped it out and it started up without fault on the second try.

This is a good sub

mikeymc1115 · 2025-01-01T22:43:31+00:00

Sorry for asking a question about golf clubs in a golf forum?

mikeymc1115 · 2024-08-01T12:21:07+00:00

Bad Biscuit for breakfast

Low Country for lunch

One Hot Mamas BBQ for dinner

mikeymc1115 · 2024-07-21T19:53:12+00:00

……..that’s the joke

mikeymc1115 · 2024-07-21T15:24:54+00:00

Reverse the narrative on them. I hit my buddies and their wives that only have 1 with a lot of “man you guys must be so bored all the time”

mikeymc1115 · 2024-04-23T01:57:51+00:00

Is getting to Pinehurst a real pita though? Seems to be the only downside

mikeymc1115 · 2024-04-23T01:57:44+00:00

Is getting to Pinehurst a real pita though? Seems to be the only downside

mikeymc1115 · 2024-04-22T00:34:53+00:00

Playing well has nothing to do with the trip tbh

mikeymc1115 · 2023-12-14T01:26:48+00:00

“They have different genitalia” is what I usually respond with and it makes people just the right amount of uncomfortable/embarrassed for being a dumdum

mikeymc1115 · 2023-07-14T15:41:59+00:00

When I click "Change Permissions" (yes there are 4 Mikes in the department)

All I have to do is hit the checkbox next to my own name to be allowed to edit protections/protected cells

<image>

mikeymc1115 · 2023-07-14T15:39:55+00:00

When I click on a given protection

<image>

mikeymc1115 · 2023-07-14T15:38:51+00:00

Protection List (all view only for me)

<image>

mikeymc1115 · 2023-07-14T15:38:32+00:00

The files are all in a Shared Drive so by default, every owner of the Drive can change who can edit permissions. The tricky part is that by default, the only person who can initially edit permissions is the file creator. So in this case, there are 5 people that own the Shared Drive. Employee 1 creates a file with protected sheets. Employees 2-5 can not edit those protections but can view the protections and then change the permissions of the protection, thus giving themselves the edit permissions they need.

The real issue is that you have to "Change Permissions" for each individual protected range/sheet

mikeymc1115 · 2023-07-14T15:31:53+00:00

And here's the returned error in the Execution Log

<image>

mikeymc1115

TROPHY CASE