Printable Version | Subscribe | Add to Favourites
New Topic New Poll New Reply
Author: Subject: Excel String help needed
Ivan

posted on 12/12/14 at 08:21 AM Reply With Quote
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?

View User's Profile View All Posts By User U2U Member
Ivan

posted on 12/12/14 at 08:25 AM Reply With Quote
Ok - found the answer - Place curser in right place and hit AltEnter.
View User's Profile View All Posts By User U2U Member
Naffa

posted on 12/12/14 at 08:26 AM Reply With Quote
Alt + Enter should put text on a new line for you in the same cell.
View User's Profile View All Posts By User U2U Member
minitici

posted on 12/12/14 at 09:20 AM Reply With Quote
...and on a mac running Excel use

ctrl+ alt+ enter

View User's Profile Visit User's Homepage View All Posts By User U2U Member
JMW

posted on 12/12/14 at 09:46 AM Reply With Quote
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.
View User's Profile View All Posts By User U2U Member

New Topic New Poll New Reply


go to top






Website design and SEO by Studio Montage

All content © 2001-16 LocostBuilders. Reproduction prohibited
Opinions expressed in public posts are those of the author and do not necessarily represent
the views of other users or any member of the LocostBuilders team.
Running XMB 1.8 Partagium [© 2002 XMB Group] on Apache under CentOS Linux
Founded, built and operated by ChrisW.