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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to trim spaces from entered text in cell using exisiting funct
You will need to use a "helper" column to do any changes and then copy/paste
special= values to either the original column or the helper column; then delete column not required. "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. 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to trim spaces from entered text in cell using exisiting functions?
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to trim spaces from entered text in cell using 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. Pocket Excel is a very trimmed down version and does not support anything beyond pretty basic functions. I have a pocket pc mainly for finding my way using a Bluetooth connected gps, I have never found anything interesting in Pocket Excel except testing it's limitations after reading postings about it that I can't do with my cell phone. I think it's too small to do anything really useful, entering anything on a pocket pc with that little pin is a real hassle Peo |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to trim spaces from entered text in cell using exisiting functions?
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. |
Reply |
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 |