Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Placing a Return in a Function
I am trying to link two cells together with an return between them. Everytime that I do this I end up with a little square in between the two values. An example of the formula that I am using is as follows: =A1&" "&A2 I want my single cell A3 for example to look like this: 23 50 And not like this 23[]50. Please Help. Thanks. -- jdurrmsu ------------------------------------------------------------------------ jdurrmsu's Profile: http://www.excelforum.com/member.php...o&userid=27122 View this thread: http://www.excelforum.com/showthread...hreadid=467562 |
#2
|
|||
|
|||
=a1&char(10)&a2
and that does not even work Only workaround I can think of is wrapping the text and shrinking the column width. Or a3 has a1 and b3 has a2 and wiping out the border. "jdurrmsu" wrote: I am trying to link two cells together with an return between them. Everytime that I do this I end up with a little square in between the two values. An example of the formula that I am using is as follows: =A1&" "&A2 I want my single cell A3 for example to look like this: 23 50 And not like this 23[]50. Please Help. Thanks. -- jdurrmsu ------------------------------------------------------------------------ jdurrmsu's Profile: http://www.excelforum.com/member.php...o&userid=27122 View this thread: http://www.excelforum.com/showthread...hreadid=467562 |
#3
|
|||
|
|||
=a1&char(10)&a2
It will work but wrap text has to be enabled for that cell. "jdurrmsu" wrote: I am trying to link two cells together with an return between them. Everytime that I do this I end up with a little square in between the two values. An example of the formula that I am using is as follows: =A1&" "&A2 I want my single cell A3 for example to look like this: 23 50 And not like this 23[]50. Please Help. Thanks. -- jdurrmsu ------------------------------------------------------------------------ jdurrmsu's Profile: http://www.excelforum.com/member.php...o&userid=27122 View this thread: http://www.excelforum.com/showthread...hreadid=467562 |
#4
|
|||
|
|||
Thanks. I tried the Char(10) as well and it did not work. I forgot to enable the word wrap function and that was the problem. Thanks. -- jdurrmsu ------------------------------------------------------------------------ jdurrmsu's Profile: http://www.excelforum.com/member.php...o&userid=27122 View this thread: http://www.excelforum.com/showthread...hreadid=467562 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to return the current Worksheet name? | Excel Worksheet Functions | |||
pmt function in Excel does not return correct monthly payment amou | Excel Worksheet Functions | |||
Function to return value from each tab | Excel Worksheet Functions | |||
return recordset | Excel Discussion (Misc queries) | |||
Function to return the latest non-zero value in a range of cells . | Excel Worksheet Functions |