For filtering purposes, how do I convert a column of ID's into ID's with a comma between?

You may have a report or export with a column of ID numbers, and you to filter by these IDs. First, you need to convert the list of ID's into the format required for a filter (ID's separated by a comma).

1. Copy the column of ID numbers

2. Open a new Word document and right-click, then select paste “Keep Text Only”
   
   

   

3. Use the Find and Replace tool in Microsoft Word to find "^p" [paragraph mark] and replace with a comma.
   
   

   

4. Then, select Filter
   
   
   

   

5. Paste the list of ID numbers, separated by commas, into the ID field

You can filter to include all these ID number records OR, by clicking the gray strikethrough symbol on the right, you can exclude all these records.