Email
New Feature Excel Flash Fill Use it for Quick Data Retrieval and Formatting
Use a great new feature of Excel 2013 and Excel 2016 - Flash Fill - to save time getting your data from text strings. Read the article now and save a ton of time!
EXPLORE THE LIBRARY
Tag: Text
Char
How-to Add a Hard Return to an Excel Concatenate Formula
Like most Excel users, one of the first formulas that you ever learned to master was the Concatenate Function. But how do you add other controls like a Hard Return or a Tab to your Concatena
Text
How to Fix Excel Wrap Text Feature when Your Rows Stop Expanding
In Excel, you will frequently have text that is longer than the cell width and you will often use the Wrap Text feature to make it more readable. However, have you ever had a row that stoppe
Email
How-to Split Up Email Address Text with Excel Formulas – Part 2
Learn how to create dynamic Excel formulas using text functions to breakup or split an email address into First Name, Middle Name, Last Name and Domain Name.
Challenge
Friday Challenge – Splitting Up Email Address Text with Excel Formulas
How to separate names from email addresses using formulas in Excel spreadsheets
Bar Chart
How-to Make a Tenant Timeline Excel Dashboard Chart
How to make an Excel dashboard chart that shows when a lease ends for a tenant.
Single Quote
How-to Show an Apostrophe at the Beginning of a Text String in Excel
Great for VBA worksheet names when you need a single quote or apostrophe before the formula named range
CSV
What to Do When Formulas Don’t Work from an Exported Salesforce.com Report or CSV Text Spreadsheet
How to fix formulas to display values instead of formula text in an excel spreadsheet when working with a downloaded or exported Salesforce.com Report or file
Data
The Best Way to Separate Address Text to Multiple Columns
Step by step tutorial and video that will show you the formulas to break up address information (street, city, state zip code) from one cell to multiple columns
Concatenate
How NOT to use Concatenate Function to build Dynamic Text in your Excel Dashboard Templates
Advice and Ways to build Concatenate formulas in your Excel Dashboard Templates.