SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Microsoft Office Tutorials and Downloads
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

Microsoft Excel 2013 Flash Fill Samples

Microsoft Excel 2013 Flash Fill data assistant tool enables automatic data entry based on pattern detected on sample entries by Excel 2013. If you refer to Excel tutorial What is Flash Fill in Microsoft Excel 2013? you can have detailed information on Flash Fill besides samples given in this guide.

Split String using Flash Fill

In our previous Flash Fill tutorial, we have seen how Excel 2013 Flash Fill can help you to concatenate text in cells. Now let's now work on the opposite and try to split text in a cell into pieces. Flash Fill can also help Excel users to split string in cells. Let's work on the sample data for string splitting. Enter full names of your friends in a single column on an Excel sheet as follows.

Split first name from fullname using Excel 2013 Flash Fill

Enter the first name of the first row on a second cell. This will give the hint to split the first word from remaning text to Excel 2013 Flash Fill engine. Go to the cell below and press Ctrl+E or Data > Data Tools > Flash Fill
Now you will have all first names of full names splitted apart as seen in below sample.

Microsoft Excel 2013 flash fill to split text stored in cells

You can continue to split text for the last name from full name example. Go back to the first row and in a new cell enter the lastname from the full name. In the below cell, activate Flash Fill using Ctrl+E short-cut key.

Extract Number from String using Flash Fill

An other Flash Fill example that I want to share with Excel users is extracting numbers from text stored in a cell. Assume you have dimensions of your products stored in a cell. In this example, I have weight in numbers with the measured unit together. In the first row for weight column, I extract and write manually the first value.

extracting numbers from string values using Flash Fill in Excel 2013

Then when I go to below row and press Ctrl+E for executing Flash Fill to enter following cells data automatically, you will have the following result.

Excel 2013 Flash Fill to extract numbers from text

Excel 2013 users can continue the Flash Fill example to fill data in units cell too. Just go to first row and type the unit of measure manually by extracting from the concatenated string value. Then in the below line, call Flash Fill to complete data entry for you.

Capitalize String with Flash Fill

An other task Excel 2013 users can use Flash Fill is to capitalize text stored in a cell. In a new cell on the same row, type the text once more but this time capitalize the first letter. And in the following row press Ctrl+E to call Flash Fill for populating remaining data automatically for the Excel user.

capitalize text using Flash Fill in Microsoft Excel 2013

Here is the output after Flash Fill in Microsoft Excel 2013 is called.

capitalizing string with Flash Fill

Extract Zip Code from Address using Flash Fill

Since generally zip code data is found at the end of address information, Flash Fill can extract zip code or post code from address data easily. But do not forget, flash fill fetches the last number found in address text in the following example case. In fact, it does not recognize zip code data as a post code or zip code, just returns last numeric value.

use Flash Fill for zip code in address data

If you press Ctrl+E or follow Excel menu options Data > Data Tools > Flash Fill, you will see zip code or post code stored in address data will be automatically extracted from others and displayed in the target column values.

populate post code from address in Excel 2013

Microsoft Office

Office 2013 Download
Install Office 2013
Activate Office 2013
Download Office 2010

Download Project 2016
Project 2013 Download
Project 2010 Download

Visio 2013 Download

Outlook Social Connector

Microsoft Office 2010, Office 2013 Download, Tutorial and Articles
Create Word Document for Label Printing using Excel Data
Color Cell Background Partially in Excel using Data Bars
Import Contacts to Outlook from VCF Export File
Cannot Open Hyperlink URL from Outlook Emails
Download Microsoft Project 2016
Import Data from SQL Server in Excel Document using Microsot Query
Outlook Social Connector for Facebook and LinkedIn
Change Default File Locations for Microsoft Office Documents
ScanPST and ScanOST Office Outlook Repair Tool
Calculate Age in Excel using DateDif Excel Function
Compact Outlook PST File
How to view Outlook Folder Size
Download Microsoft Visio 2013 Professional Edition free
Microsoft Excel 2013 Flash Fill Data Entry Assistant Tool
Microsoft Excel 2013 Flash Fill Samples
How to Install Microsoft Office 2013
How to Activate Microsoft Office 2013
Free Microsoft Project 2013 Download Trial Edition
Free Microsoft Office 2013 Download
Microsoft Office 2013: Couldn't install Office. Please try installing again
Microsoft Project 2013 for Office Developers
LinkedIn Outlook Social Connector Download
Download Microsoft Outlook Social Connector for Facebook
Free Download Microsoft Office for Mac 2011
How to Create Master Project, SubProject in Microsoft Project 2010
Microsoft Project 2010 Download Free Trial
Microsoft Project 2010 Team Planner
Add Column to Gantt Chart in Microsoft Project 2010
Copy and Email Timeline in Microsoft Project 2010
Microsoft Project 2010 Activation Error
Microsoft Office 2010 Installation (Professional Plus Edition)
Microsoft PowerPivot Download for Office 2010 Excel
Microsoft Office Redistributable Primary Interop Assemblies Download
Free Download Microsoft Office 2010
How to Save Office Communicator IM Conversation to Communicator Conversation History Folder
Restore Outlook Personel Folder from Outlook .pst (Outlook Data) File

Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems