+ Reply to Thread
Results 1 to 2 of 2

Converted Address Label PDF File to Text File and need to get it working in Excel

  1. #1
    Registered User
    Join Date
    02-08-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Converted Address Label PDF File to Text File and need to get it working in Excel

    Hi everyone,

    I'm new on this forum, but I have an issue. I have a client who gave me a PDF file, particularly it is an address label style. There is no known files for such Word document using this address labels, so I'm stuck with that option.

    I have already used PDF and converted them to text document. Now my text documents are showing all in lines.

    John Smith
    123 Ranch Rd.
    Chicago, IL 60001
    Jane Smith
    324 Circle Ct.
    Chicago, IL 61101
    Don King
    7384 Church Ave.
    Rockford, IL 73489
    Robert Marsden
    3734 Oregon Trail
    Evansville, MO 34793

    So you get the idea, I have hundreds of people in this format in Notepad. I can copy and paste it in Excel, but it just becomes as one Collumn. I can't figure how to have it separate it in every 3 Lines? My Goal is to get it to be converted to make it work in MS Word 2007. I looked multiple options, nothing seemed to help online, nor in MS help.

    Thank you,
    Samuel

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,754

    Re: Converted Address Label PDF File to Text File and need to get it working in Excel

    If the layout in the notepad files is like your uploaded example you could test the following.

    In Excel click "Data" tab then select "From Text" -> click on file you wish to import -> "Import" -> "Next" -> "Next" -> "Finish"

    as target select A1

    Having done the import you then run this macro to split info in blocks of 3 with a blank cell between each block.

    Please Login or Register  to view this content.
    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1