Adding variable number of blanks

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

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

Much thanks - works like a charm!!! And so simple too.
John

Originally Posted by Toppers

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