Manipulate Text in Excel without formula

In this tutorial, learn how to manipulate text in Excel with AI. FlashFill, Excel’s smart tool, helps you extract specific details from cells quickly.

• FlashFill recognizes patterns in your data to extract or combine parts of text automatically.
• It’s ideal for extracting details like first names from full names or reformatting phone numbers with ease.
• This feature is essential for anyone looking to save time and simplify data tasks.

Simply show Excel what you want, and FlashFill completes it, making repetitive tasks a breeze!

Click on the following button to start the tutorial to manipulate text like a Pro in Excel.

 

Start

1.

Merge cells

You want to merge 2 cells, like Firstname and the LastName, for more than 100 rows .... What do you do?

Copy them one by one? 🤔 In fact, that's the idea but this is where AI will help you. In fact, Excel will "understand" the pattern you will write to fill for you the other cells. Magic? No FlashFill 😀🏆

 

For example in this example, we want to group the first name followed by the last name

1. Select the cell adjacent to the table (the tool should be attached to the data table)
2. Write the result you want 'HAYLOM Simon'
3. Next, go to the next line
4. Start by writing the first letters of the LastName, here only M
5. Automatically, Excel 'proposes' a list based on the first value entered
6. If the list matches what you want to create, you just need to confirm by pressing Enter
7. That's it! You've combined the first and last names for all the other cells 👍

 

 

FlashFill is case-sensitive (uppercase/lowercase).

In this new example, we want the First and last names in lowercase.

 

Next page

 Loading...

 

The other courses in this module

1. Number Format in Excel
2. Excel Alignment text tips
3. Learn the secrets of Sorting Data
4. Filtering your data
5. Automatically extracting or merging cells
6. Creating a dropdown menu

Excel-Tutorial.com, your training partner.

The purpose of Excel-tutorial.com is to help users master Excel through a series of tests, tutorials, and online training programs. Whether you're a beginner or an advanced user, our resources are designed to build your skills step by step.

Our certified experts have developed detailed training programs tailored to all skill levels. Our courses cover various Excel topics, from basic data processing to advanced data analysis and visualization. You'll find clear instructions, easy-to-follow lessons, and structured content that ensures steady progress.

Excel-tutorial.com stands out for its interactive teaching approach. Our lessons include exercises, real-life use cases, and engaging quizzes to solidify your understanding. This lets you apply your new skills immediately to real-world tasks, making learning both practical and impactful.

Plus, you can track your progress and test your knowledge with quizzes that provide instant feedback. Our goal is to help you gain confidence in Excel, one concept at a time. Join us at Excel-tutorial.com and start transforming your data skills today!