![]() |
Concatenate: Multi-Line Cell with 2 single line cells
Using Excel 2003, SP2:
The following is to allow a cut and paste of the required data into a text file, while maintaining a "columner" look to the data. FIRST: Looking to Concatenate cell C?, (which could be anything from a single line to perhaps, 25 lines long), with D? and E?, each of which will only be 1 line long. Is this possible? If so, is there any control as to which line the D and E cells would line up with? If there is an option, the end result would be most legible, if the D & E line up with the topmost line of C. IF the above doesn't stop this project in its tracks, I will try to use various formulas found in this ng from Dave Peterson, to see if I can get Columns D and E spaced out, so that it still looks like a spread-sheet. Thankyou |
All times are GMT +1. The time now is 09:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com