Dear fine people of Mr. Excel,
I am not sure if this has a possible solution, but here is my problem...
I have a pdf with a large list of hyperlinks which have a text description attached to them. I tried many different ways of copy and paste to get them formatted correctly in excel to no avail.
However, I was able to separate them into groups of cells with a blank cell in between. Some groups are three cells, some are two cells.
Here is an example of what I mean...
<tbody>
</tbody>
What I would like to do is be able to combine each group into one cell respectively (i.e., "Data1a-c" in one cell, and "Data2a-b" in one cell, etc) using a macro on the whole sheet.
I have so many of these groups that it will take far too long to manually combine them one by one.
Thank you for your time, and I hope to hear from you soon!
Warm Regards,
Nate Zona
I am not sure if this has a possible solution, but here is my problem...
I have a pdf with a large list of hyperlinks which have a text description attached to them. I tried many different ways of copy and paste to get them formatted correctly in excel to no avail.
However, I was able to separate them into groups of cells with a blank cell in between. Some groups are three cells, some are two cells.
Here is an example of what I mean...
Data1a |
Data1b |
Data1c |
Data2a |
Data2b |
Data3a |
Data3b |
Data3c |
Data4a |
Data4b |
Data5a |
Data5b |
Data6a |
Data6b |
<tbody>
</tbody>
What I would like to do is be able to combine each group into one cell respectively (i.e., "Data1a-c" in one cell, and "Data2a-b" in one cell, etc) using a macro on the whole sheet.
I have so many of these groups that it will take far too long to manually combine them one by one.
Thank you for your time, and I hope to hear from you soon!
Warm Regards,
Nate Zona