Snippet that extracts the contents of a specified spreadsheet cell after the whole contents of the spreadsheet have been copied to the clipboard.
{note}{formtext: name=cell; default=a1; width=4} << Enter the cell reference{endnote}
{note: preview=no}
This extracts the column letter and row number from the form field.
{columnLetter=upper(extractregex(cell,"(\D+)"))}
{rowNumber=extractregex(cell,"(\d+)")}
This assigns numbers to the respective letters e.g. A=1, B=2 etc
{columnIndex=["A"=1,"B"=2,"C"=3,"D"=4,"E"=5,"F"=6,"G"=7,"H"=8,"I"=9,"J"=10,"K"=11,"L"=12,"M"=13,"N"=14,"O"=15,"P"=16,"Q"=17,"R"=18,"S"=19,"T"=20,"U"=21,"V"=22,"W"=23,"X"=24,"Y"=25,"Z"=26]}
{colNumber={=columnIndex[columnLetter]}}
{endnote}
{note}Contents from cell {=columnLetter}{=rowNumber}: {endnote}{=catch({=split({=split({clipboard},"\n")[{=rowNumber}]},"\t")[{=colNumber}]},"Nothing found")}