top of page
Search
Writer's pictureKennie Nybo Pontoppidan

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



Don't modify you PATH variable while in flight...

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:

7 views0 comments

Commentaires


bottom of page