Skip to main content

Flash Fill

A series of names appears in column A. The heading in column B indicates you want first initial and last name. Type the desired result in B2. Select the empty cell B3.

Type the first initial in B3. Excel sees what you are doing and “grays in” a suggested result.

As soon as you start to type the first initial in B3, Excel "greys in" the answers for the rest of the column using Flash Fill. Press Enter and the results will become permanent.

Press Enter to accept the suggestion. Bam! All of the data is filled in.

Look carefully through your data for exceptions to the rule. Two people here have middle initials listed. Do you want the middle initials to appear? If so, correct the suggestion for Dennis P. Jancsy in cell B4. Flash Fill will jump into action and fix Martha K. Wendel in B9 and any others that match the new pattern. The status bar will indicate how many changes were made.

In the above case, Excel gurus could figure out the formula. But Flash Fill is easier. In the example shown below, it would be harder to write a formula to get the last word from a phrase that has a different number of words and more than one hyphen.

In this case, column A contains three fields. An account number, the account name, a hypen, and then the industry in lower case. Type the first industry in B2, using Proper Case.

Flash Fill makes this easy. Go to cell B3 and press Ctrl+E to invoke Flash Fill.

Use Flash Fill and the rest of the industries are filled in.

Note

Flash Fill will not automatically fill in numbers. If you have numbers, you might see Flash Fill temporarily “gray in” a suggestion but then withdraw it. This is your signal to press Ctrl+E to give Flash Fill permission to fill in numbers.

Labels:

Comments

Post a Comment

Popular posts from this blog

Rethinking Agentic AI

 # Rethinking AI Agents: Why Intelligence Beats Integration Every Time ## More Tools Won't Save a Thoughtless Agent Every week, another development team ships an AI agent loaded with integrations — web search, vector databases, code runners, calendar hooks, payment gateways. The demo looks impressive. The stakeholders nod. Then the agent hits its first real user in a messy, unpredictable situation, and the cracks appear fast. The uncomfortable truth? Most AI agents fail not because they lack access to information, but because nobody taught them how to *think* about it. The industry has quietly developed a bad habit: treating agent-building like a hardware upgrade. Slow processor? Add RAM. Agent underperforming? Add tools. This logic sounds reasonable until you realize that intelligence doesn't accumulate through connection counts. A library card doesn't make someone well-read. --- ## Competence Isn't a Plugin Here's a useful mental test. Imagine hiring someone for a...
Post a Comment
Read more

Why Every BI Professional Needs to Learn Agentic AI in 2026

Meta Description:  Agentic AI is transforming business intelligence. Learn why BI professionals must embrace autonomous AI agents to stay relevant — with practical examples, skills to build, and a BI Lead's honest perspective on the shift. Tags:   Agentic AI  ·  Business Intelligence  ·  Power BI  ·  AI Agents  ·  Data Analytics  ·  Future of BI  ·  Career Growth Let me be blunt: if you're a BI professional in 2025 and you haven't started paying attention to agentic AI, you're already behind. I'm not saying that to scare you. I'm saying it because I've spent over a decade building dashboards, tuning SQL queries, and wrangling Power BI data models — and nothing in my career has shifted the landscape as fast as agentic AI. Not self-service analytics. Not cloud migration. Not even the first wave of AI/ML. This is different. And here's why. What Exactly Is Agentic AI? Forget the chatbot hype for a second. Agentic AI refer...
Post a Comment
Read more

Quantum Computing

  Quantum computing is a new kind of computing that uses the laws of quantum physics to solve certain problems much faster than classical computers.  It doesn’t replace your laptop but can tackle very complex simulations, optimization, and cryptography‑style tasks that are intractable for ordinary machines.  *** ### What is quantum computing? Quantum computing is a computing paradigm that uses quantum‑mechanical phenomena—like superposition, entanglement, and interference—to represent and process information in new ways. Instead of classical bits (0 or 1), quantum computers use **qubits**, which can be in a mix of 0 and 1 at the same time, enabling parallel computation.  *** ### Classical bits vs. qubits - A **classical bit** is either 0 or 1; operations are deterministic and sequential.  - A **qubit** can be 0, 1, or any quantum “blend” of both, written as $$ \alpha|0\rangle + \beta|1\rangle $$, where $$ \alpha $$ and $$ \beta $$ are complex numbers capturing p...
Post a Comment
Read more