Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard returns in a formula?
Is there a way to insert a hard return into a formula that joins text from 2
or more cells? =B1 & B2 I'd like to have 2 hard returns after B1. Is this possible? The result of the formula should appear as: "Sentence 1 Sentence 2" Can this be done with a formula? Thanks, Paul |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard returns in a formula?
try
=b1 &" "&b2 format alignment as wrap text and use as many spaces as necessary -- Don Guillett SalesAid Software "PCLIVE" wrote in message ... Is there a way to insert a hard return into a formula that joins text from 2 or more cells? =B1 & B2 I'd like to have 2 hard returns after B1. Is this possible? The result of the formula should appear as: "Sentence 1 Sentence 2" Can this be done with a formula? Thanks, Paul |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard returns in a formula?
Don,
This doesn't work due to a limit in formula length. Maybe there's another way to do this. I have a textbox that is populated by joining the text from multiple cells. However, I need the final output (textbox) to be displayed with some hard returns. This textbox is supposed to be sort of a preview of what the body text of an email will look like when sent. I hope this makes since. Paul "Don Guillett" wrote in message ... try =b1 &" "&b2 format alignment as wrap text and use as many spaces as necessary -- Don Guillett SalesAid Software "PCLIVE" wrote in message ... Is there a way to insert a hard return into a formula that joins text from 2 or more cells? =B1 & B2 I'd like to have 2 hard returns after B1. Is this possible? The result of the formula should appear as: "Sentence 1 Sentence 2" Can this be done with a formula? Thanks, Paul |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard returns in a formula?
One can also try the key combination Alt-Enter while edit the cell formula. :) -- yellowbeetle ------------------------------------------------------------------------ yellowbeetle's Profile: http://www.excelforum.com/member.php...o&userid=31326 View this thread: http://www.excelforum.com/showthread...hreadid=510092 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard returns in a formula?
=B1&CHAR(10)&CHAR(10)&B2
set wraptext and widen the row to suit -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "PCLIVE" wrote in message ... Is there a way to insert a hard return into a formula that joins text from 2 or more cells? =B1 & B2 I'd like to have 2 hard returns after B1. Is this possible? The result of the formula should appear as: "Sentence 1 Sentence 2" Can this be done with a formula? Thanks, Paul |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard returns in a formula?
Very good Bob! That's exactly what I was looking for.
Thanks for your help. Paul "Bob Phillips" wrote in message ... =B1&CHAR(10)&CHAR(10)&B2 set wraptext and widen the row to suit -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "PCLIVE" wrote in message ... Is there a way to insert a hard return into a formula that joins text from 2 or more cells? =B1 & B2 I'd like to have 2 hard returns after B1. Is this possible? The result of the formula should appear as: "Sentence 1 Sentence 2" Can this be done with a formula? Thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My formula returns a result but the cell displays a zero? | Excel Worksheet Functions | |||
How to put hard returns in a cell without going to the next cell | Excel Discussion (Misc queries) | |||
Excel hard code those #'s without deleting the formula or typing# | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
What formula can you use to compound monthly returns? | Excel Worksheet Functions |