Creates a quoted, comma separated list of values

New-QuotedString.ps1

function New-QuotedString {
    <#
    .SYNOPSIS
    Takes a pasted set of cells from Excel and returns a quoted, comma separated string that can be pasted into SSMS for a SQL filter

    .DESCRIPTION
    Long description

    .PARAMETER ItemsList
    The cell list from Excel as a string - just paste inside a pair of quotes and assign that to a variable

    .EXAMPLE
    $x = "Books
Cheese and biscuits
Humous"
    $x | New-QuotedString
    
    result:
    'Books','Cheese and biscuits','Humous'

    .NOTES
    Author:   @fatherjack
    Date:     20220228
    #>
    [CmdletBinding()]
    param (
        [Parameter(ValueFromPipeline = $true)]
        [string]
        $ItemsList
    )

    process {
        "'{0}'" -f ($ItemsList -replace ("`r`n", "','"))
    }
}