ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   formula results take up to 2 lines if needed, but keep border (https://www.excelbanter.com/excel-worksheet-functions/40957-formula-results-take-up-2-lines-if-needed-but-keep-border.html)

smurf

formula results take up to 2 lines if needed, but keep border
 
l D l E
l
1 lowners: l______________________________________________l
2 l________l________________________________________ ______l
3 laddress:l________________________________________ ______l

-I use Excel 2003
-This is a form I print out for my business.
-E1's fomula is =B9
-D2, E1, E2, E3 all have a border line on the bottom
-If the results only take 1 line I want it in E1.
-I want the formula results to take up E1 & E2 if needed but not loose the
border line on the bottom of both cells.
-When I wrap text combining E1 & E2 I loose the border line on the bottom
of E1.
-I am pretty sure there isn't a way that D2 can be included along with E1 &
E2, if there is please tell me.


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com