![copy paste list into excel separated by semi colons copy paste list into excel separated by semi colons](https://support.copper.com/hc/article_attachments/360039436153/multiple_email_addresses.png)
- #COPY PASTE LIST INTO EXCEL SEPARATED BY SEMI COLONS HOW TO#
- #COPY PASTE LIST INTO EXCEL SEPARATED BY SEMI COLONS ZIP#
Then you click “Split the Data,” and voila! The Creuz Your Data app creates little data batches perfectly sized for your Pardot rule criteria: Then you tell it what size chunks you need (again 250 characters for Pardot rules in dynamic lists, 1,000 characters for Salesforce report filters): Then you click “Data Manipulation” to add commas or semi-colons as needed:
![copy paste list into excel separated by semi colons copy paste list into excel separated by semi colons](https://apprize.best/microsoft/excel_11/excel_11.files/image285.jpg)
Play around with it - it’s pretty simple to use! Interacting with it is actually easier than explaining it, but basically, you throw your text in the box: Internally we are calling the little wizard embedded above the “ Creuz Your Data app.” Because “thing-that-splits-and-transforms-data-for-use-in-Pardot-rule-criteria” is hard to say five times fast. (If you’re on mobile and the embed above is being fussy, click here.) Introducing the Creuz Your Data App Think multiple thousands of values.Īfter some collectively groaning in our internal Slack about how long this was going to take, we started brainstorming ways to make the process easier, and Mike Creuzer and Russell Thomas came up with this:
![copy paste list into excel separated by semi colons copy paste list into excel separated by semi colons](https://docs.metasfresh.org/webui_collection/EN/assets/Excel_table_product_data.png)
My team and I were on the brink of creating a dynamic list with suuuuuper long criteria recently for one of Sercante’s clients to do an account based suppression. A tool that makes this process a breeze (& why I love working with people smarter than me)
#COPY PASTE LIST INTO EXCEL SEPARATED BY SEMI COLONS HOW TO#
This kind of takes forever, it’s error prone, but it’s the best way that I know how to do it. Copy and paste the chunks into multiple filters Roughly eyeball or use Word character count to break the resulting block of text into chunks that were around 250 values.Į. Use “Find & Replace” to insert a semi-colon any time there’s a ^p (Word speak for a line break)ĭ. Open Word and do a “Paste Special” as unformatted unicode text.Ĭ. Open Excel and copy the column of values needed for the filterī.
![copy paste list into excel separated by semi colons copy paste list into excel separated by semi colons](https://8tppw38uh9w16lbyc2wl0ik1-wpengine.netdna-ssl.com/wp-content/uploads/2014/07/show-csv-button.png)
In the past, to make this a little easier, this is the process that I’ve followed:Ī. So then you have to make multiple rule filters and do a “match any:” (In Salesforce report filters, this is 1,000 characters - better, but still limiting.) You’re limited to 250 characters per rule. You separate them with semi-colons and paste them into your rule filter, like so:īut with a large batch of values… this starts getting icky.