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