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


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

Adding variable number of blanks
 

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

Adding variable number of blanks
 

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


Toppers Wrote:
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




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