Uncategorized
No Friday Challenge – I was hacked :(
Hi All, Thanks for your patience, but if you visited my site in the last 36 hours, you may have noticed that I was hacked 🙁 But all is better (I hope) and we are up and running again! Not fu
EXPLORE THE LIBRARY
Month
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 Answer Part 1: Splitting Up Email Address Text
How-to Splitting Up Email Address Text with Excel Formulas using text to columns
Challenge
Friday Challenge – Splitting Up Email Address Text with Excel Formulas
How to separate names from email addresses using formulas in Excel spreadsheets
Concatenate
How-to Concatenate Excel Column or Row Data Using Google Docs
How to use Google Docs to Concatenate a range in Excel without the using a formula. Best for lots of data to concatenate or when you want to do it quickly.
Find and Replace
How-to Find and Replace a Hard Return in an Excel Spreadsheet
Find or find and replace a hard return in excel workbook
Challenge
Thanks for the Friday Chart Challenge Submissions – Vote in the Poll!
I had some AMAZING submissions for the last Friday Excel Chart Challenge. Check out the post and file downloads here: Friday-excel-challenge-submissionswhich-chart-solution-one-do-you-like-b