From Greg Tyber@21:1/5 to All on Fri Nov 3 15:00:45 2023
I have a sheet with a bunch of rows and columns that I intend to paste into a document. I would like to create a list of Acronyms used in the spreadsheet into a table to also past into a document. Is there a way to extract unique words with uppercase
letters to a new sheet.
Example
A1: This word is CAPS and this WORD also
A2: Thank YOU
B1: ALL that we want is LOVE
B2: NO Problem
Result on new sheet
A1: CAPS
A2: WORD
A3: ALL
A4: LOVE
A5: YOU
A6: NO