![Don't modify you PATH variable while in flight...](https://static.wixstatic.com/media/d27dfd1a1116f0780e1e8d8ba324c3aa.jpg/v1/fill/w_980,h_654,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/d27dfd1a1116f0780e1e8d8ba324c3aa.jpg)
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:
![](https://static.wixstatic.com/media/8e82a4_62ec22ae008949f7ae879b4e7d1ee460~mv2.png/v1/fill/w_297,h_210,al_c,q_85,enc_avif,quality_auto/8e82a4_62ec22ae008949f7ae879b4e7d1ee460~mv2.png)
Tip 2
In windows command prompt, you can pipe to the clip board buffer:
![](https://static.wixstatic.com/media/8e82a4_5708dd93b53b4087b53a85a43a469f61~mv2.png/v1/fill/w_352,h_112,al_c,q_85,enc_avif,quality_auto/8e82a4_5708dd93b53b4087b53a85a43a469f61~mv2.png)
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:
![](https://static.wixstatic.com/media/8e82a4_220ec7a749ef49c7b151dcca25c5a555~mv2.png/v1/fill/w_163,h_95,al_c,q_85,enc_avif,quality_auto/8e82a4_220ec7a749ef49c7b151dcca25c5a555~mv2.png)
Under the Data tab, choose "Text To Columns"
![](https://static.wixstatic.com/media/8e82a4_ec412e4a94c6428ea0040946452a3d9c~mv2.png/v1/fill/w_980,h_385,al_c,q_90,usm_0.66_1.00_0.01,enc_avif,quality_auto/8e82a4_ec412e4a94c6428ea0040946452a3d9c~mv2.png)
Now, follow the wizard:
![](https://static.wixstatic.com/media/8e82a4_9ac55bde96de4f0499593823b092b14e~mv2.png/v1/fill/w_980,h_752,al_c,q_90,usm_0.66_1.00_0.01,enc_avif,quality_auto/8e82a4_9ac55bde96de4f0499593823b092b14e~mv2.png)
![](https://static.wixstatic.com/media/8e82a4_c2c0ea001c834b7db6380953d666e9d4~mv2.png/v1/fill/w_885,h_699,al_c,q_90,enc_avif,quality_auto/8e82a4_c2c0ea001c834b7db6380953d666e9d4~mv2.png)
and voila
![](https://static.wixstatic.com/media/8e82a4_8559e7e68e3448b6aee2f687683d626e~mv2.png/v1/fill/w_355,h_97,al_c,q_85,enc_avif,quality_auto/8e82a4_8559e7e68e3448b6aee2f687683d626e~mv2.png)
Stay tuned for more small tips and tricks...
Watch the full episode of Defrag tools episode 132 here:
Comments