Try:
=REPT(" ",32-LEN(A1))& A1
"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 (that part I can do) 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=560816