truncating text

Giganews Newsgroups
Subject: truncating text
Posted by:  scott_cairns
Date: Wed, 10 May 2006

hello

i would like to create a cell that truncates the titles of books to 16
characters and no spaces.

so for instance if A1 reads "The Religions of India", I would B1 to read
"thereligionsofin" ... no uppercase and no spaces.

I realise that excel may not be the best place to manipulate data like this,
but is it possible? thanks!

Replies