| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine text functions
I would like to remove trailing characters using trim and change case within
one formula. Can that be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine text functions
You mean something like: =UPPER(TRIM(A1)) or =LOWER(TRIM(A1)) -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115476 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine text functions
Thanks all, but I figured it out. Just nest the Proper as the first argument
of the Trim. Thanks! "Kay" wrote: I would like to remove trailing characters using trim and change case within one formula. Can that be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine ISNA and IF functions | Excel Worksheet Functions | |||
| How to combine, IF, AND, OR Functions | Excel Worksheet Functions | |||
| Possible to combine VLOOKUP and IF(AND) functions? | Excel Worksheet Functions | |||
| Combine functions? | Excel Worksheet Functions | |||
| Combine functions into one cell | Excel Worksheet Functions | |||
Linear Mode
