Dominic Goodman

Born again,humble,always real,born in the BIBLE BELT & a CHELSEA fan..a faithful in deed,,,,married!
Retweets & Likes do not necessarily mean endorsements!!!!

[Symon Shah @FarmBastion]

@WMutunga @lynn_ngugi1 This time there are options:
I propose most governors be elected independent candidates to ensure MCA supervise them
President we need a candidate who will reset our clock
MPs should ONLY be elected if
-Married within
-Have a known home within
-Have a running business

[Dr. Miguna Miguna @MigunaMiguna]

To @WilliamsRuto:

Why are 99.99% of all OCSs in Nairobi Kalenjins?

What are you planning with them? This is unacceptable!

Fellow Kenyans: circulate this widely, expose, ORGANIZE and EXTERMINATE this tribalism and PLAN to commit and conceal atrocities in Nairobi.

Police Station| OCS

Kilimani Police Station| OCS David Kipchumba Koech

Buruburu Police Station| OCS Ben Kipkorir Sang

Kasarani Police Station| OCS Joseph Kiplagat Bii

Embakasi Police Station| OCS Daniel Kiptoo Rotich

Lang'ata Police Station| OCS John Kipng'etich Keter

Parklands Police Station| OCS Wilson Kipkurui Bett

Kamukunji Police Station| OCS Kiptoo Lang’at

Jogoo Road Police Station| OCS Michael Kiprotich Kosgey

Industrial Area Police Station| Amos Shamalla

Gigiri Police Station| OCS Andrew Kipchirchir Kirui

Karen Police Station| OCS Eric Kiplangat Mutai

Kileleshwa Police Station| OCS Timothy Kipchoge Ngeno

Runda Police Station| OCS Philip Kiptoo Boit

Riruta Police Station| OCS Vincent Kipkorir Yego

Kangemi Police Station| OCS Christopher Kiprono Langat

Waithaka Police Station| OCS Paul Kipkemoi Barchok

Mutuini Police Station| OCS Henry Kipngeno Tuwei

Kayole Police Station| OCS Geoffrey Kiprotich Chepkonga

Dandora Police Station| OCS Richard Kipchirchir Lagat

Kariobangi Police Station| OCS Alex Kiprono Birech

Huruma Police Station| OCS James Kipkemoi Korir

Makongeni Police Station| OCS Edwin Kiptoo Kanda

Shauri Moyo Police Station| OCS Bernard Kiplangat Cherono

Mowlem Police Station| OCS Collins Kipkorir Kigen

Njiru Police Station| OCS Robert Kipchumba Sigei

Ruai Police Station| OCS Victor Kipkemoi Kemboi

Mukuru Kwa Reuben Police Station| OCS Patrick Ndegwa

Kawangware Police Station| OCS Simon Kipchirchir Talam

Zimmerman Police Station| OCS Julius Kiprono Kiptanui

Githurai Police Station| OCS Francis Kipkorir Rugut

Umoja Police Station| OCS George Mutua

Central Police Station| OCS Dishon Angoya

Pangani Police Station| OCS Henry Kandie

[𝕵𝖆𝖘 @awgecentral]

They’re in their own little world 🥹

[GBC @GBC_Press]

🚨 BREAKING:

​Israeli Zionists in the Israel Defense Forces killed a 14-year-old Palestinian boy. We need this video to go viral, please share it.

[Moe @moneyacademyKE]

77% of investors in Kenya's online forex market made losses in 2025.

We have analysed the 2025 performance of Kenya's online forex market and all licensed forex brokers.

Save & Share the thread below

[Moe @moneyacademyKE]

Kenyan forex traders lost Sh7 billion against Sh1.2 billion in wins in 2025, according to CMA data.

For every Sh1,000 invested, Sh856 was lost.

[Okiya Omtatah Okoiti @OkiyaOmtatah]

PUBLIC MONEY IS NOT EXECUTIVE PROPERTY: THE CONSTITUTIONAL TRUTH ABOUT CHAPTER TWELVE

Fellow Kenyans,
The bottom line of Chapter Twelve is simple: the Executive DOES NOT own public money, THE PEOPLE do. 
Our 2010 Constitution intentionally strips the President and Cabinet of unchecked power over your taxes through six strict principles: 
1) People Own the Funds: Government only administers public money; it never owns it. 
2) Parliament Approves Spending: The Executive cannot spend a single shilling without explicit parliamentary authority. 
3) The Treasury is Independent: Under Article 225, the Treasury is an autonomous custodian, not a political department subordinate to the Executive. 
4) Independent Oversight: The CRA, Controller of Budget, and Auditor-General ensure no single entity controls the financial chain. 
5) Personal Liability for Looting: Under Article 226(5), any official who directs unlawful spending must pay it back from their own pocket, even after leaving office. 
6) No Free-For-All Borrowing: Debt is strictly tied to legitimate budget deficits, not executive whims. 
The power of the purse belongs to the people, not the Executive. We must defend our Constitution! #ReKe #GetitDone #KnowYourConstitution #ConstitutionKe2010

https://t.co/THmleX3KBq

[Ben Kairu @bkairu5]

@moneyacademyKE @cassiedmola This is the data they cook up when they want to introduce something. Soon you”ll see some maize, wheat or orange variety whose goal is “food security” or some pesticide with one global supplier and a patent that prohibits local production.

[Cheap China @AndikaVizu31091]

@moneyacademyKE The report by FAO is trash. They cost a meal at $4.5 per person per day. Say, for family of 4, that comes to $18 on food per pay, or about 2300 kes, or 70k on food monthly. Now, we all know that's too much and food doesn't cost that much. Poor research.

[CPA Wachira Joseph @WashiraX]

KRA has graduated to a magician.

There was a real estate company called Bristol Estate limited. They excelled in flipping real estate.

By 2020, cash had dried up. They could not continue. Worse still, they owed KRA 475 million shillings.

The directors called for an emergency meeting. Then one director stood up and proposed. Let's dissolve the company.

They all said, perfect. Kill the company. Do it. Fast.

As they are doing all this, they are not aware of one dangerous sentence, sitting quietly in the companies act. It says:

• A company that has applied for dissolution must immediately give a copy of the notice to its creditors.

Why? Because the law gives creditors a chance to object before the company disappears. To protect themselves from losses.

Bristol quietly dissolved the company. They never informed their hungriest creditor, KRA.

The clock started ticking. Bristol tax returns stopped hitting KRA servers. KRA became suspicious.

KRA called the company. No answer. Eventually they reached one of the directors.

The greetings were warm. Until the caller said: This is KRA.

The director immediately switched to his Italiano: Fratello KRA, non ti capisco.

KRA replied: Hizo ni gani tena umeanza bro? We were talking just fine. Let's continue in English.
The director insisted: Non ti capisco.

KRA ignored the drama: We want our 475 million that your company owes us.
Director responded. Which company? We closed it years ago. Didn't you read the Kenya Gazette?

KRA asked: What are you saying? How can you close with our money? 475 million? Aje?

KRA rushed to the gazette. It was true. Bristol Estate Ltd had officially ceased to exist.

KRA retreated to Times Tower and embarked on a fault finding mission.
How can a company die with Caesars money?

In 2023, KRA remembered that one dangerous sentence. You remember it?

• A company applying for dissolution must notify its creditors.

KRA had never received that notice.
They immediately ran to court.

They argued: My lord, we were owed 475 million. We were a legit creditor. Bristol could not lawfully dissolve itself without notifying us. Please resurrect it.

The court agreed. The company had been dissolved through a defective process.

The judge ordered the company registrar to bring Bristol Estate Ltd back from the dead.

Not so it could sell houses. But so KRA could collect its 475 million in taxes.

Case closed.

Lessons.

- Closing a company does not automatically erase its tax debts.

- Before dissolving a company, notify all creditors. Including the hungriest creditor of them all, KRA.

- If the dissolution process is defective, the court can resurrect the company.

[𝐄𝐋𝐈 𝐉𝐀𝐄 @Elijaemusic]

If this song doesn't make your playlist, I'll be surprised.

[〽️o r e i r a @MetodoMoreira]

A Toyota investe cerca de $5 bilhões por ano em publicidade e propaganda

Porém a melhor propaganda de todas foi criada gratuitamente por um de seus clientes

[MovieTalks🎬🍿 @jackofficial_01]

The Showdown Between Old and New Special Forces Kings 9.5/10

[Meech @MeechAura]

This game had everything. 😮‍💨🍿

[UK in Kenya 🇬🇧🇰🇪 @UKinKenya]

Pure Quality from Declan

[MovieTalks🎬🍿 @jackofficial_01]

Great Movie where actions speaks louder than words

[Dr. Eng. John Mativo CP³P @MativoMJohn]

Ala! Tanzanians are not just our neighbors, they are literally our relatives.

Good History lesson 👍🏼

[House Republicans @HouseGOP]

“The communist system is the opposite of the American system, and the communist system has never worked. Our warriors did not fight communism on battlefields across the world only to have that menace rear its ugly head right back here in America. We're not going to let it happen.”

- President Trump, July 4, 2026

[Polymarket Sports @PolymarketSport]

🚨CONTROVERSIAL: VAR didn’t call this as a penalty OR a foul in the build up to Argentina’s 3rd goal…

…Egypt had an earlier goal ruled back for a foul in the build up

[Tips Excel @gudanglifehack]

🚀 Excel Formulas Fundamentals — Part 8

📝 Text Functions for Data Cleaning & Manipulation

In real-world datasets, text data is often inconsistent. Names may have extra spaces, different letter cases, or be combined into one field.

Text functions help you clean, extract, combine, and standardize text efficiently.

📌 These functions are heavily used by Data Analysts, Business Analysts, HR teams, and Finance professionals.

🧠 1. LEN() – Count Characters
LEN() returns the total number of characters in a cell, including spaces.
Syntax: =LEN(text)
Example: =LEN(A2)
If A2 contains Deepak
Result: 6
📌 Use Cases: Validate IDs, Check password length, Verify product codes

⬅️ 2. LEFT() – Extract Characters from the Left
Extracts a specified number of characters from the beginning of a text string.
Syntax: =LEFT(text,num_chars)
Example: =LEFT(A2,3)
If A2 = "Laptop"
Result: Lap
📌 Useful for extracting prefixes or department codes.

➡️ 3. RIGHT() – Extract Characters from the Right
Returns characters from the end of a text string.
Syntax: =RIGHT(text,num_chars)
Example: =RIGHT(A2,4)
If A2 = "INV2026"
Result: 2026
📌 Useful for extracting years, invoice numbers, or suffixes.

🔍 4. MID() – Extract Characters from the Middle
Extracts text starting from a specified position.
Syntax: =MID(text,start_num,num_chars)
Example: =MID(A2,3,4)
If A2 = "EMP12345"
Result: P123
📌 Useful for extracting parts of employee IDs or product codes.

✂️ 5. TRIM() – Remove Extra Spaces
Removes leading, trailing, and extra spaces between words.
Syntax: =TRIM(A2)
Example:
Before: John Doe
After: John Doe
📌 Essential for cleaning imported data.

🔠 6. UPPER(), LOWER(), PROPER()
These functions standardize text case.

UPPER()
=UPPER(A2)
Result: JOHN DOE

LOWER()
=LOWER(A2)
Result: john doe

PROPER()
=PROPER(A2)
Result: John Doe
📌 Useful for customer names, addresses, and reports.

🔗 7. CONCAT() and & – Combine Text
Using &
=A2&" "&B2
If A2 = John, B2 = Doe
Result: John Doe

Using CONCAT()
=CONCAT(A2," ",B2)
📌 Combines multiple text values into one.

📋 8. TEXTJOIN()
Joins text with a chosen delimiter.
Syntax: =TEXTJOIN(", ",TRUE,A2:A5)
Example:
Names: Rahul, Priya, Amit
Result: Rahul, Priya, Amit
📌 Useful for generating email lists or summaries.

🔄 9. SUBSTITUTE()
Replaces specific text with new text.
Syntax: =SUBSTITUTE(text,old_text,new_text)
Example: =SUBSTITUTE(A2,"Yes","Approved")
If A2 = "Yes"
Result: Approved
📌 Great for standardizing values.

🛠️ 10. REPLACE()
Replaces text based on position.
Syntax: =REPLACE(old_text,start_num,num_chars,new_text)
Example: =REPLACE("ABC123",1,3,"XYZ")
Result: XYZ123
📌 Useful when the position of the text is fixed.

🔎 11. FIND() and SEARCH()
Both functions return the position of text inside another text string.

FIND() Case-Sensitive
=FIND("Excel",A2)

SEARCH() Case-Insensitive
=SEARCH("excel",A2)
Example: If A2 = "Learn Excel Today"
Result: 7
📌 Useful for checking whether a keyword exists in a text string.

🎯 Mini Practice Project
Create: Customer_Data.xlsx
Data:
First Name | Last Name | Full Name | Customer ID
john | doe | CUST-2026-001

Tasks:
✅ Convert names to Proper Case
=PROPER(A2)

✅ Create Full Name
=A2&" "&B2

✅ Remove Extra Spaces
=TRIM(C2)

✅ Extract Year from Customer ID
=MID(D2,6,4)

✅ Count Characters in Customer ID
=LEN(D2)

🏆 End of Part 8
After completing this lesson, you should be able to:
✅ Extract text using LEFT(), RIGHT(), and MID()
✅ Clean data using TRIM()
✅ Standardize text with UPPER(), LOWER(), and PROPER()
✅ Combine text using CONCAT(), TEXTJOIN(), and &
✅ Replace and modify text using SUBSTITUTE() and REPLACE()