| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to trim spaces from entered text in cell using exisiting functions?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
