ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Concatenate: Multi-Line Cell with 2 single line cells (https://www.excelbanter.com/excel-worksheet-functions/130963-concatenate-multi-line-cell-2-single-line-cells.html)

BEEJAY

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