Google Answers Logo
View Question
 
Q: Limiting number of Textual Characters displayed in an excel cell ( No Answer,   2 Comments )
Question  
Subject: Limiting number of Textual Characters displayed in an excel cell
Category: Computers
Asked by: dzchamp-ga
List Price: $2.00
Posted: 23 Jun 2004 08:58 PDT
Expires: 23 Jul 2004 08:58 PDT
Question ID: 365087
How do i trim the data of a cell from 150+ characters of TEXT to
display less than or equal to 150 characters with cell formating. 
Additionaly how can I make "..." included after the cut off point?  I
need the command line since i have 1000+ cells in this column that
need to be treated.
Answer  
There is no answer at this time.

Comments  
Subject: Re: Limiting number of Textual Characters displayed in an excel cell
From: 1anton1-ga on 23 Jun 2004 10:04 PDT
 
Assuming your data is in column A then:

Put this is column b - you don't need a command line - just highlight
the area you want to fill and click paste and it will work out the
formula correctly for the selected range:

=LEFT(A1,150) & IF(LEFT(A1,150)<>A1,"?","")

If you like, you can then hide column A
Subject: Re: Limiting number of Textual Characters displayed in an excel cell
From: dreamboat-ga on 26 Jun 2004 06:42 PDT
 
I don't believe it would be possible using cell formatting, and I
believe 1anton1 has the best answer you'll get unless you need it
automated with VBA.

After you have used 1anton1's formula, you can select the new cells,
copy, then Edit-Paste Special-Values, and delete your original column.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy