Finally in PowerShell 5, there is support for sending results to the clipboard, and receiving results from the clipboard:

PS> Get-Command -Noun Clipboard 

CommandType Name          Version Source                         
----------- ----          ------- ------                         
Cmdlet      Get-Clipboard Microsoft.PowerShell.Management
Cmdlet      Set-Clipboard Microsoft.PowerShell.Management

For example, you can open Excel with some sheets of data, copy a column into the clipboard, and then in PowerShell tap into this data and filter it:

PS> $list = (Get-ClipBoard) -like '*err*'

Twitter This Tip! ReTweet this Tip!