| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to truncate list of meaningful words greater than 15 chars tomeaningful words of 8 chars.
Hi,
I am in a fix to downsize the names in a list for example. GRONG GRONG BORAMBOLA MT MUNDOONEN MOORLAND FSROL HALFWAY CREEK TIMBILLICA HILL TELEGRAPH POINT CULLENDULLA BENDERNEER GRASSTREE MORUYA NORTH LOMOND HILL GENOA NORTH LATROBE VALLEY FERNY HILLS POWRANNA TOORLOO ARM NEWMERELLA CABBAGE TREE CREEK SPROLE CASTLE HINCHINBROOK NATIONAL PARK EL ARISH WAUGHS POCKET TURTLE CREEK BEACH WANGETTI FSRER OAK BEACH CUNNINGHAMS GAP WEST CUNNINGHAM GAP EAST PORT VINCENT CELLer EDITHBURGH caouth YORKETOWN CELL ASHVILLE Fever MARGARET RIVER How can some one truncate them into 8 char words with meaning ful one word |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restrict no of chars in text box | Excel Discussion (Misc queries) | |||
| sum first 2 chars if 3rd is something... | Excel Discussion (Misc queries) | |||
| Truncate words | Excel Worksheet Functions | |||
| determine if ea value in a col has more than 20 chars | Excel Discussion (Misc queries) | |||
| Header/Footer max 255 chars | Excel Discussion (Misc queries) | |||
Threaded Mode
