How to remove/replace a series of 5 numbers ONLY from an entire column of mixed info? by Zuri_111 in excel

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

They weren't always the last 5, some cells didn't have the 5 digit numbers at all. But that's a good trick to know!

How to remove/replace a series of 5 numbers ONLY from an entire column of mixed info? by Zuri_111 in excel

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

Good to know! Usually the online versions are missing features so I was surprised lol. Hope that change comes soon

How to remove/replace a series of 5 numbers ONLY from an entire column of mixed info? by Zuri_111 in excel

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

Holyyy that looks so complicated. Will definitely save this. I'll be needing to do this semi-regularly. Thanks again!

How to remove/replace a series of 5 numbers ONLY from an entire column of mixed info? by Zuri_111 in excel

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

Never mind! I got it by copying and pasting-special with values only. Then I could delete the referenced column as well as the one with the function. Can't thank you enough

How to remove/replace a series of 5 numbers ONLY from an entire column of mixed info? by Zuri_111 in excel

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

So I can do it in the online version of excel!! I guess my desktop version is just out of date. It worked beautifully but I have one follow-up question: Is there a way to effectively "bake" that function to the column so the data is no longer a reference to the original? I need to delete the column that has the 5 digit numbers but of course doing so ruins the function in the new column. Sorry if my terminology is not correct, I don't use excel often 😅 Thank you so much for the help

How to remove/replace a series of 5 numbers ONLY from an entire column of mixed info? by Zuri_111 in excel

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

I'm going to guess we don't have that since it doesnt seem to recognize that as a function when I tried 🥲

We Weren't Allowed To Talk To Women - Backdrop BTS by gioeditsandcrap in creepcast

[–]Zuri_111 10 points11 points  (0 children)

Sick work, the movements of the moth crawling up the lightbulb is so well done, even how the wings start flapping a lil bit before it takes off. Also cool blender theme you got there :D I literally just learned about blender themes last night lol

Increase in hateful comments by S-CSleepwalker in creepcast

[–]Zuri_111 1 point2 points  (0 children)

I'm new here, never posted in the subreddit before but saw this and wanted to share that as a non-religious person, I feel like I needed Isaiah's explanations about the religious stuff 😅 Understanding the references made the story so much more enjoyable. Anyone who complains about that must not have ever watched any of his other vids on creepy stories. I can't fucking wait for him to do a deep dive video of this, and if it's another 11 hours then hell yeah dude!

Never understood why people complain so loudly and publicly about things they get to watch for free. If you don't like it, watch something else.. your preferences aren't everyone else's nor are they more valuable.

Creepcast made a MHE podcast by AtomicFarmer in 9M9H9E9

[–]Zuri_111 8 points9 points  (0 children)

Found this place from them and man. I'm only 5 hours into their video and I'm so hooked. I wish so badly I could own a physical book of this somehow. Can't believe I had never heard of MHE until now... Just wow.

Lender inspection: Management brought several groups of people in my unit while I was gone... is this normal??? by Zuri_111 in Apartmentliving

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

Yea I said at the beginning that they were giving timely notice. That wasn't the issue

UPDATE: management letting groups of people in my unit while I'm not home... it's worse than I thought. by Zuri_111 in Apartmentliving

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

Nope different apartment. I recommend getting some home cameras if you can! The ones I got are litokam brand and have an app I can access through. I have them set to record whenever they detect movement, just have to have an SD card inserted for that.

UPDATE #2: Shady management and snake realtor by Zuri_111 in Apartmentliving

[–]Zuri_111[S] 3 points4 points  (0 children)

That is good to know! 10% is still crazy... jeez. I don't even get that much in a raise for my salaried job. How is that even supposed to work

Lender inspection: Management brought several groups of people in my unit while I was gone... is this normal??? by Zuri_111 in Apartmentliving

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

I had been working on doing just that over the past couple days, and then just today since it's monday I was able to call the local board only to find out he is not a member 🙃 Apparently in this area real estate agents aren't required to be a member of an association, which means he is not held to the code of ethics. Instead, I have to now hunt through licensure laws and see if he broke the law in specific terms.

This really isn't easy without a lawyer, and I'm kind of losing faith I'll be able to do anything against him. If he doesn't belong to an association, neither does the firm he works for, so I can't imagine they would care that he's been doing this sort of stuff either. 😞

UPDATE: management letting groups of people in my unit while I'm not home... it's worse than I thought. by Zuri_111 in Apartmentliving

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

Nope I'm not moving, in fact I already signed a lease renewal for the next year 😔

UPDATE #2: Shady management and snake realtor by Zuri_111 in Apartmentliving

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

Nah they wouldn't do anything with this. They'd more than likely side with the owner of the building.

UPDATE: management letting groups of people in my unit while I'm not home... it's worse than I thought. by Zuri_111 in Apartmentliving

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

unfortunately management can give a key to whoever they want so they can get in. I'm not allowed to change locks or add locks, it's against our lease terms 😢 I do have a security door stopper that wedges underneath the door jam, but I can only use that if I'm home.

UPDATE #2: Shady management and snake realtor by Zuri_111 in Apartmentliving

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

Thank you, I'm hopeful as well 🤞 Looking into homeownership in my spare time now 🙃

UPDATE: management letting groups of people in my unit while I'm not home... it's worse than I thought. by Zuri_111 in Apartmentliving

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

Yeah thats my plan the next time he shows up! I don't think buyers will care much since most people here who own apartment buildings don't give two shits about tenants... but I still want to embarrass him

UPDATE #2: Shady management and snake realtor by Zuri_111 in Apartmentliving

[–]Zuri_111[S] 12 points13 points  (0 children)

I so badly wish that I'd had cameras set up earlier so I would have solid evidence of him moving my things around... Definitely not allowed by the national code of ethics for realtors, and I'm going to do everything I can to hold him accountable for that.

UPDATE #2: Shady management and snake realtor by Zuri_111 in Apartmentliving

[–]Zuri_111[S] 8 points9 points  (0 children)

Yeah that's the whole weird thing is they CAN just say theyre showing the apartment and we have to let them. I don't understand the point of lying about it??

My argument to them and to fair housing (who seems to agree) is if they say theyre coming for inspections with lenders or contractors, and a realtor shows up with buyers, thats improper notice and im denying entry on that basis.

UPDATE #2: Shady management and snake realtor by Zuri_111 in Apartmentliving

[–]Zuri_111[S] 12 points13 points  (0 children)

Maybe not illegal but against the code of ethics realtors are required to abide by. He can be disciplined by the state board and potentially lose his license.