+ Reply to Thread
Results 1 to 3 of 3

Text dash hyperlink, split to two columns to paste into Excel.

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,464

    Text dash hyperlink, split to two columns to paste into Excel.

    I have a Word document (attached). For each line I have the Singer as text, then a dash, then the song as a hyperlink. I want to paste these into 2 columns in my Excel file, but if I copy as is from Word it pastes into a single cell with the whole value as a hyperlink.

    I'm thinking there should be some kind of Advanced Filter or Text to Columns feature in Word that will allow me to break my document into two columns, one for the artist, one for the hyperlink, which I could then paste into Excel, but I'm not very Word conversant, so can't figure out how to do it. Any help would be appreciated.
    Attached Files Attached Files
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,815

    Re: Text dash hyperlink, split to two columns to paste into Excel.

    Hi Jomili,

    In Word, select all of your text, then click Insert > Table > Convert Text to Table. Set the 'Separate text at' to 'Other' and specify a dash (if it didn't automatically do that for you like it did for me). Click OK, and you should have your two-column table.

    You can then copy/paste into Excel keeping the hyperlinked songs, or paste matching destination formatting which will remove the hyperlinks leaving just the text.

    Hope that helps!

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,464

    Re: Text dash hyperlink, split to two columns to paste into Excel.

    That was EXACTLY what I needed. Thanks so much for showing me how!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Import from text files and split into columns in Excel
    By kay007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2018, 07:22 AM
  2. Split list up and copy and paste into 2 different columns
    By cwby44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2014, 04:30 PM
  3. Excel macro to merge columns with dash in between
    By bsambrano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2012, 04:22 PM
  4. split text into more columns excel
    By ibarrera in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2006, 12:00 PM
  5. Split text , uniformly paste in rows and columns.
    By nshanmugaraj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2006, 09:15 AM
  6. understanding dash dash in a excel formula
    By ldebner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2005, 10:05 AM
  7. [SOLVED] Paste into Excel w/o Text to Columns
    By comish4lif@verizon.net in forum Excel General
    Replies: 1
    Last Post: 08-16-2005, 06:05 PM

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