Ivan
|
| posted on 12/12/14 at 08:21 AM |
|
|
Excel String help needed
I have an excel cell with the following string in it:
8.3.1 PSA 8.3.1 PSA 8.21
I nee the string to look like this in the single cell and to stay the same if column width changes so adding spaces between doesn't work.
8.3.1
PSA 8.3.1
PSA 8.21
Can anybody help?
|
|
|
|
|
Ivan
|
| posted on 12/12/14 at 08:25 AM |
|
|
Ok - found the answer - Place curser in right place and hit AltEnter.
|
|
|
Naffa
|
| posted on 12/12/14 at 08:26 AM |
|
|
Alt + Enter should put text on a new line for you in the same cell.
|
|
|
minitici
|
| posted on 12/12/14 at 09:20 AM |
|
|
...and on a mac running Excel use
ctrl+ alt+ enter
|
|
|
JMW
|
| posted on 12/12/14 at 09:46 AM |
|
|
You could also format the cell(s) to wrap text, but then excel will decide where to break rather than you based on the new column width. It will still
try to use space as the obvious crlf point but that may not suit, as I notice in your example you split on some spaces but left others.
|
|
|
