|Date:||Wed, 10 May 2006|
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!