convert word doc into excel table (delete some content)

Posted on 2011-04-26
Last Modified: 2012-05-11
The word doc is a list of clubs (three word name with hyperlink),
street address and suburb and postcode.

I am seeking an excel table of 3 columns containing
the name of the club (three word name including the hyperlink)
the suburb name (can be one two or three words after
the comma)
the postcode.

The street address is to be omitted.
Question by:gregfthompson

    Author Comment

    LVL 15

    Accepted Solution

    There is no easy way to do this without using some kind of delimiter like a comma or hyphen. If the spacing were even after the name of the club, that would help out also. I suggest adding some kind of delimiter after the club name and suburb so you can separate them easier in Excel.

    For example, the first two should be modified to look like:

    Rotary Club of Southbank,  Garden Room Crown Towers Hotel, 8 Whiteman Street, Southbank, 3006
    Rotary Club of Albert Park,  Lifesaving Victoria, Cnr Todd Rd & The Boulevard, Port Melbourne, 3207

    See the extra commas added in bold. If you can get it to that format so every section is separated by a comma, you can copy/paste it directly into Excel. Then go to Data > Text to Columns and put in a comma as the delimiter to use. It will separate all those lines for you in Excel and you can get rid of the column for street address by highlighting the column and deleting it.
    LVL 15

    Expert Comment

    Hmmm...The bold commas didn't stand out as much as I thought. But basically, add it after each section (Club Name, Street Address, Suburb, postal code).

    Author Closing Comment

    Thank you!!!
    LVL 30

    Expert Comment

    gregfthompson: You might want to re-open the question as it is possible to achieve what you want without formatting your original text.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
    This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
    Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now