binar
04-25-2011, 03:31 PM
Fellow Forum Members,
I'm crossing tabulated data over from a PDF file. The problem is that it does not paste into Excel 2007 in the same tabulated format. A paragraph of text pasted into cell A1, most of the time ends up spread across cell A1, A2, and A3. I tried using the merge cell command as a way of joining all the text strings together into a single paragraph in cell A1 and the drawback to this option is that it drops text.
Can anyone out there help me develop a macro that does the following:
I horizontally highlight cells A1, A2, A3 and A4 then click a macro command button and then the text strings inside these cells join together as a single text paragraph inside cell A1. The same thing happens vertically. If I select cells E4, E5, E6 then click a button the text in all three cells join together in cells E4. The order of how the text strings join together is determined by the increasing letter or number of the cell location ID.
In short, is such a Macro possible? I have tried concatenating but this falls short because I need a more automated solution.
Any help will be greatly appreciated. Thanks.
I'm crossing tabulated data over from a PDF file. The problem is that it does not paste into Excel 2007 in the same tabulated format. A paragraph of text pasted into cell A1, most of the time ends up spread across cell A1, A2, and A3. I tried using the merge cell command as a way of joining all the text strings together into a single paragraph in cell A1 and the drawback to this option is that it drops text.
Can anyone out there help me develop a macro that does the following:
I horizontally highlight cells A1, A2, A3 and A4 then click a macro command button and then the text strings inside these cells join together as a single text paragraph inside cell A1. The same thing happens vertically. If I select cells E4, E5, E6 then click a button the text in all three cells join together in cells E4. The order of how the text strings join together is determined by the increasing letter or number of the cell location ID.
In short, is such a Macro possible? I have tried concatenating but this falls short because I need a more automated solution.
Any help will be greatly appreciated. Thanks.