Back

If your email is not recognized and you believe it should be, please contact us.

  • You must be logged in to reply to this topic.Login

Import Excel list of names and format with bullets in between

Return to Member Forum

  • Author
    Posts
    • November 2, 2012 at 11:37 am #63487
      fiebska
      Member

      Hi everyone, first post on this great forum. I've used your tricks a few times and was hoping someone could help me with this.

      I have an Excel spreadsheet with a long list of names (+500) in a single column that I would like to import somehow (even copy/paste) that will allow me to automatically format them into an order where one is right after the other with a bullet in between.

      Excel data:

      John Smith

      Mary Watson

      Mike Lee

      etc.

      Convert to InDesign:

      John Smith * Mary Watson * Mike Lee * etc. filling out multiple pages justified.

      I don't need any other organization or formatting help than that.

      Thanks in advance if anyone has an idea on this!

    • November 2, 2012 at 11:45 am #63488
      David Blatner
      Keymaster

      I would probably just search (using Find/Change) for ^p (caret p) and replace it with space-asterisk-space or something like that. Plus, select the text, then open find/change and choose Selection from the Search pop-up menu in the find/change dialog box (to limit the scope to just that text). No grep neceesary. :)

    • November 2, 2012 at 12:03 pm #63489
      fiebska
      Member

      Oh man I knew it had to be something like that.

      Thanks a lot David, I'm away from my desk but I'll be sure to try that and I'm positive that will work.

      Thanks again!

      EDIT: Worked like a charm!

  • Author
    Posts
Viewing 2 reply threads
  • The forum ‘General InDesign Topics (CLOSED)’ is closed to new topics and replies.
Forum Ads