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.

For example if I enter a letter in A1 I've tried the formula LOWER(A1) in A1
but I can't do this due to a circular reference error.

thanks
rj