-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
hard returns
-
T
Hard returns when using &
Hello all, I am using "&" to link data from cells to build a directory (Column A Phone Number, Column B Ext). Is it possible to install a built in hard return? I tried putting the hard return (Alt+Enter) in the formula, but that did not work. In the screen shot below, how do I put a hard...- tobysdhc
- Thread
- hard returns
- Replies: 5
- Forum: Excel Questions
-
F
Finding Carriage returns with Conditional Formatting
I have an excel sheet that occasionally uses carriage returns in certain cells to display multiple lines of data. These cells are merged for formatting reasons and this cannot be changed. Merged cells cannot use auto-fit row height, so it must be done manually so all data will be visible. I'm...- Fyresparxx
- Thread
- carriage returns conditional formatting hard returns
- Replies: 3
- Forum: Excel Questions
-
A
Add hard returns within cell at maximum 255 characters, for 2000 lines
The following sample narrative needs to be uploaded to our offsite storage facilty database, which needs a hard return at maximum 255 characters, but I would like the hard return at the beginning of each client matter number. So the cell will go from this: 4-2512 Wilbert Carl breuer, II v...- atlmsk
- Thread
- 255 character max hard returns insert
- Replies: 10
- Forum: Excel Questions
