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

Cleanly Trimming text...
 

if i got u right, try :

=A2&" "&B2&" "&C2&" "&D2&" "&2&.....

Cleanly Trimming text...
 

=LEFT((A2 & B2 & C2),255)





wrote in message
oups.com...
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

Cleanly Trimming text...
 

Okay I like the LEFT method, better then the MID method, but it still
will not chop off gracefully. I would rather have 8 attributes in the
string taking up 240 characters, then 9 attributes at 255 with the 9th
attribute being cut off.

HotRod wrote:
=LEFT((A2 & B2 & C2),255)





wrote in message
oups.com...
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