Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I show only the last portion of text in a multi line cell? | Excel Worksheet Functions | |||
More than one line in a single cell? | New Users to Excel | |||
Multi line merged cell - adapting to different size input - possible? | Excel Discussion (Misc queries) | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions |