StringOf32 = Left(OrigString & Space(32), 32)

"ringnab" wrote:


I need to copy cell entries into another program that then puts a
perspective resize on the text. In order for the perspective to work
properly, the content has to be exactly 32 characters in length so I
need something that will figure out the current number of characters in
the cell but then add the appropriate number of blank spaces.
Thanks in advance.
John


--
ringnab
------------------------------------------------------------------------
ringnab's Profile: http://www.excelforum.com/member.php...o&userid=35876
View this thread: http://www.excelforum.com/showthread...hreadid=560825