View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default How to truncate list of meaningful words greater than 15 chars to meaningful words of 8 chars.

Ron

This is shaping up to be interesting<g


Gord

On Fri, 29 Apr 2011 07:31:15 -0400, Ron Rosenfeld wrote:

On Thu, 28 Apr 2011 23:39:10 -0700 (PDT), Babloo wrote:

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


I don't know. The best I could come up with would be to remove all the vowels, <space's and any duplicated consonants. But that would not get you down to 8 letters. Your resultant list would look like:

GNNRTH
LTRBVLY
FRNYHLS
PWRN
TRLRM
NWMRL
CBGTRCRK
SPRLCSTL
HNCHNBRKNTNLPRK
LRSH
WGHSPCKT
TRTLCRKBCH
WNGTFSR
KBCH
CNGHMSGPWST
CNGHMGPST
PRTVNCNTCLr
DTHBRGHcth
YRKTWNCL
SHVLFvr
MRGRTRVR

I suppose if the result were longer than eight characters, you could either truncate the result or take every other character. But I don't know how "meaningful" the result would be.

GRNGRNG
BRMBL
MTMNDN
MRLNDFSR
HLFWYCRK
TMBLCHL
TLGRPHPN
CLNDL
BNDRNR
GRSTR
MRYNRTH
LMNDHL
GNNRTH
LTRBVLY
FRNYHLS
PWRN
TRLRM
NWMRL
CBGTRCRK
SPRLCSTL
HNCHNBRK
LRSH
WGHSPCKT
TRTLCRKB
WNGTFSR
KBCH
CNGHMSGP
CNGHMGPS
PRTVNCNT
DTHBRGHC
YRKTWNCL
SHVLFVR
MRGRTRVR