| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trim leading spaces
I am trying to trim leading and ending spaces with bl3 = UCase(bl1) 'convert to uper case LTrim (bl3) RTrim (bl3) however it does not work any ideas -- captain bob ------------------------------------------------------------------------ captain bob's Profile: http://www.excelforum.com/member.php...o&userid=36988 View this thread: http://www.excelforum.com/showthread...hreadid=567887 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trim leading spaces
Try using:
bl3 = UCase(Trim(bl1)) "captain bob" wrote: I am trying to trim leading and ending spaces with bl3 = UCase(bl1) 'convert to uper case LTrim (bl3) RTrim (bl3) however it does not work any ideas -- captain bob ------------------------------------------------------------------------ captain bob's Profile: http://www.excelforum.com/member.php...o&userid=36988 View this thread: http://www.excelforum.com/showthread...hreadid=567887 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trim leading spaces
I should have also mentioned that you have to assign the result of the
LTrim/RTrim to a variable. So this should also work: bl3 = UCase(bl1) bl3 = LTrim(bl3) bl3 = RTrim(bl3) "Jay" wrote: Try using: bl3 = UCase(Trim(bl1)) "captain bob" wrote: I am trying to trim leading and ending spaces with bl3 = UCase(bl1) 'convert to uper case LTrim (bl3) RTrim (bl3) however it does not work any ideas -- captain bob ------------------------------------------------------------------------ captain bob's Profile: http://www.excelforum.com/member.php...o&userid=36988 View this thread: http://www.excelforum.com/showthread...hreadid=567887 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to trim spaces from entered text in cell using exisiting functions? | Excel Worksheet Functions | |||
| Keeping leading 0's | Excel Discussion (Misc queries) | |||
| How do I add leading spaces to a value? | Excel Worksheet Functions | |||
| Strip leading spaces from cell | Excel Worksheet Functions | |||
| Remove Leading Spaces | Excel Discussion (Misc queries) | |||
Hybrid Mode
