FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

February 9, 2016

TheExcelAddict.com Quote of the Day

“When it is obvious that the goals cannot be reached,
don’t adjust the goals, adjust the action steps."
-– Confucius --


Hi fellow Excel Addict,

Francis Hayes (TheExcelAddict.com)Another snowstorm dumped on us today. Luckily it wasn't as bad as predicted. The forecast said 35cm (14in) of snow but we got just 17cm (7in). But, as is usually the case in eastern Newfoundland, the temperature is starting to rise and all that snow likely will melt away once again. (Sorry I don't have any new snow pics today)

I appreciate you joining me today for another 'Excel in Seconds' time-saving tip that I hope you will find helpful.

If you missed Thursday's tip that showed how to 'Delete Hundreds of Blank Rows in Seconds', 
you can still read it here just like Penny did. She emailed me to say "I was easily able to follow your clear, step by step instructions.  What I could have done in minutes using the filter feature, I was able to complete in SECONDS using this method."

Please feel free to share this newsletter with anyone else you think it may help.


Take care and keep Excelling,

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com





If you missed my last newsletter, you can click here to view it online.



Mynda's Excel Dashboard Reporting CourseDo you use Excel to create reports for senior
management (or anyone else for that matter)?
Do your reports take complex data from multiple sources and consolidate them into one clear and concise report...on just one page?

Do your reports include the right charts that best displays your data?

Do your reports include interactive controls so that the reader can change views and scenarios 'on the fly'?

Do your reports update in seconds with almost no manual data input?

If you have answered NO to any of these questions, you are probably not using Excel Dashboards for your reports.

An Excel Dashboard is a fully-interactive and dynamic reporting tool that you can build right in Excel using the tools you already have.

Would you like to see Excel Dashboards in action and even learn how to create an interactive Excel Dashboard...for FREE?

Mynda's Excel Dashboard Reporting CourseMynda's Excel Dashboard Reporting Course



Excel in Seconds with TheExcelAddict.com

Split Your Data Using 'Text to Columns' Without Destroying the Original Data


Typically, when you split a column of data using Text to Columns (TTC), the data gets split, starting in the column containing the original data, and then is distributed over the columns to the right. This destroys your original data.

However, you CAN split the data and still keep the original column intact.

Right there on Step 3 of the TTC wizard (Data tab, Text to Columns), there is a Destination field. Using the Destination field gives you the option to choose a different cell where the results of the split data will go. The split data will then be 'copied' to the destination cell and the original column of data will be preserved.

Text To Columns Choose Destination Cell_in_Microsoft_Excel_2007_2010_2013_2016_365
Sometimes when you split data with TTC using the default destination, you'll receive a message saying "There is already data here. Do you want to replace it?". This indicates that there is some data in the columns to the right.

Text To Column Data Exists Overwrite Message_in_Microsoft_Excel_2007_2010_2013_2016_365
The 'destination' option in Step 3 of the Wizard allows you to output the TTC results to an empty area of your worksheet.


FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Thanks for supporting this newsletter and website


Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630