View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Babloo Babloo is offline
external usenet poster
 
Posts: 1
Default 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