Tips and Tricks part 1 - PATH, pipe to clip, and the Text To Columns feature in Excel

Watching Defrag tools episode 132, I learned a few small Windows/Excel tricks that I want to share with you.

Tip 1

In windows command prompt, you can type PATH to get the content of the PATH system variable printed to the screen:

Tip 2

In windows command prompt, you can pipe to the clip board buffer:

Tip 3

In Excel, you can transform delimited data in a cell to columns using the Text To Columns feature:

Say that you have marked a cell with comma-separated values:

Under the Data tab, choose "Text To Columns"

Now, follow the wizard:

and voila

Stay tuned for more small tips and tricks...

Watch the full episode of Defrag tools episode 132 here:

https://channel9.msdn.com/Shows/Defrag-Tools/Defrag-Tools-132-PATH

#Tipsandtricks #Excel #cmd