February 9, 2016
Hi fellow Excel Addict,
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)
If you missed my last newsletter, you can click here to view it online.
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.
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.
The 'destination' option in Step 3 of the Wizard allows you to output the TTC results to an empty area of your worksheet.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630