Board logo

Excel String help needed
Ivan - 12/12/14 at 08:21 AM

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 - 12/12/14 at 08:25 AM

Ok - found the answer - Place curser in right place and hit AltEnter.

Naffa - 12/12/14 at 08:26 AM

Alt + Enter should put text on a new line for you in the same cell.

minitici - 12/12/14 at 09:20 AM

...and on a mac running Excel use

ctrl+ alt+ enter

JMW - 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.