importing excel into indesign for mac getting rid of extra rows

Importing Excel Into Indesign Getting Rid Of Extra Rows How To Do It
Importing Excel Into Indesign Getting Rid Of Extra Rows Zip Code Columns

Add an Action app to your Zap, and you can now use that text in any other appno manual editing needed.

Help center Get help with Zapier from our tutorials, FAQs, and troubleshooting articles.

Community Ask questions, share your knowledge, and get inspired by other Zapier users.

Teams Companies Zapier for Teams Share and collaborate on work with your team in Zapier.

Zapier for Companies Manage multiple teams with advanced administrative controls in Zapier.

And when you see that Bob bought apple, carrot, banana, pig you know that he bought each itemnot an unholy apple-carrot-banana-pig conglomerate.

Importing Excel Into Indesign Getting Rid Of Extra Rows Zip Code Columns

Or separating an address thats in one column into separate street address, city, state, and Zip Code columns or fields.

Importing Excel Into Indesign Getting Rid Of Extra Rows How To Do It

When you have text that needs to be split up, heres how to do it in a spreadsheet like Microsoft Excel and Google Sheets or automatically split text between your favorite apps with Zapiers Formatter tool.

If the names are already in a spreadsheet, just open the spreadsheet in Excelor, if the list is somewhere else, perhaps in a document or website, just make a new spreadsheet in Excel, then copy and paste the text into the spreadsheet.

Click the Data tab in the top menu, and click Text to Columns you should see it around the middle of the toolbar.

The Delimited option should be checked by defaultthis specifies that the text you want to separate uses spaces, tabs, or other delimiters that you can choose how your data is split, so click Next.

If you have a list of comma separated values like the store list example above, check the Comma option instead.

Say, for instance, you want the domain names from a list of email addresses.

Youd check Other, type an symbol in the box, and Excel could then split the username and domain from email addresses.

You might need to do some cleanup unless your data all matches the same style.

Or, if youre using Microsoft Word, you can convert text to columnsselect the text, then click the Insert tab, then click Table - Convert.

You can then separate text by spaces, commas, tabs, special characters, and even paragraphs.

First import your spreadsheet into Google Sheets or make a new spreadsheet and paste in the data you want to split.

Google Sheets will open a small menu beside your text where you can select to split by comma, space, semicolon, period, or custom character.

Select the delimiter your text uses, and Google Sheets will automatically split your text.

Say you want to add your customers to your MailChimp email listbut your eCommerce app sends you their name as Bob Tester or Jane Doe, and MailChimp wants the name split into Bob and Tester with separate first and last names.

App automation tool Zapier can speed things up by automatically copying the customer info from your store and then adding it to MailChimp.

Select the Text action, then choose the Split Text transform.

If your text is separated by spaces, you can leave the Separator field blank; otherwise, enter the character(s) that splits your text.

Importing Excel Into Indesign For Mac Getting Rid Of Extra Rows