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 |
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 |