View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Robert.Cordani@us.schneider-electric.com is offline
external usenet poster
 
Posts: 22
Default Cleanly Trimming text...

To start with, I am creating a string, based on concatenating a large
number of attributes(cells).
Essentially using this formula for that:

=IF(ISBLANK(A2),"",A2&" ")&IF(ISBLANK(B2),"",B2&" ")...

So if you have a better way, I like to learn it.

My current question revolves around this background.
I need to limit the string to under 255.
I can find a few way to trim these, I am leaning towards the MID
function, but if I simply chop at 255 it will undoubtedly chop off mid
attribute or even mid word.

I even went as far as trying to use the search function to get the
location of a space closest to 255, but search and find seem to ONLY
look for the first instance of a character, there is no way to specify
last (or better yet search right to left).

So any suggestions out there?
TIA