|
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
|