Recent content by dark_magus

  1. dark_magus

    Table structure reformatting

    Great! It worked :) Thank you very much, HaHoBe. Wish I was such a guru in Excel, it would simplify things so much. But hey, at least I have this forum and you guys... Thank you again. Cheers, dark_magus
  2. dark_magus

    Table structure reformatting

    Hi there, I have a problem with the handling of table data. I'd like to change the following table PrimaryKey ForeignKey specy 1 1 Human 2 2 Human 3 2 Mouse 4 2 Rat 5 3 Rat 6 4 Rat 7 5 Mouse 8 5 Rat 9 6 Rat 10 7 Human 11 7 Rabbit to this format: PrimaryKey ForeignKey specy1 specy2 specy3...
  3. dark_magus

    split hyperlink to text and URL

    I have an Excel sheet full of Hyperlinks, e.g. like John Doe or Famous Sites. I'd like to split this cell to one containing the text ("John Doe") and another with the URL ("abc@yourdomain.com"). Unfortunately, I don't know how to do. Any help in this matter is appreciated.
See more
Back
Top Bottom