Hi, thanks for the response.

Yes, I do want to convert the entries automatically. I don't beleive Pocket
Excel supports Macros.
So, the only way it seems to work is to do as you suggested and use an
additional dummy cell to alter the original entry and then use the dummy
cell in other forumulas.

Thanks
rj

"Harlan Grove" wrote in message
ups.com...
rj wrote...
I want to enter a letter in a cell then trim any spaces from the text and
convert it to lower case.
Can I do this by using functions in the cell where I enter the text? I'm
developing a spreadsheet to be used by Pocket Excel so I need to use
exisiting functions.
...

If you mean you want to find some way to convert entries automatically,
there's no way to do that without macros. If Pocket Excel supports
macros, then you could use a Change event handler. If it doesn't
support macros, you simply can't do this. However, you could *enter*
into one cell [B5, say] and cleanse the entry in another cell [BB5,
say, containing the formula =LOWER(TRIM(B5))], then use the cleansed
cell [BB5] in other formulas.