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
