Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cleanly Trimming text...
if i got u right, try :
=A2&" "&B2&" "&C2&" "&D2&" "&2&..... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trimming text from the end of cell contents. | Excel Worksheet Functions | |||
Trimming/Truncating Text Field in Excel | Excel Discussion (Misc queries) | |||
Trimming text | Excel Worksheet Functions | |||
Grid column display text trimming | Excel Discussion (Misc queries) | |||
Trimming text contained in cells | Excel Programming |