Challenge
Friday Challenge – Data Transformation Solution
In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data Transformation Data Transformation Now it
EXPLORE THE LIBRARY
Tag: MID Function
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.
FIND Function
Getting to Know Excel Text Fuctions and Functions
See how to use a combination of the Excel Find Function, MID Function and Value to get a text ranking from text.
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