Skip to main content

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

Updated over a month ago

If you want to quickly filter based on a list of IDs (for example, listed in an Excel spreadsheet column), you can just copy and paste the column of numbers directly into the Contact Filter ID field. The numbers will appear each separated by a new line, which works just as effectively as comma-separated values.

However, if you particularly want to convert the list into IDs separated by commas, here's the process:

  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. In EventsAir, 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.

Did this answer your question?