Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
always need 32 characters
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
always need 32 characters
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
always need 32 characters
Private Sub DoPadTo32()
Dim sResult As String * 32 Dim cellCurr As Range Set cellCurr = ActiveCell cellCurr.Select LSet sResult = cellCurr.Value 'Documentation From Excel VBA HELP follows 'LSet stringvar = string 'LSet varname1 = varname2 'The LSet statement syntax has these parts: 'Part Description 'stringvar Required. Name of string variable. 'tring Required. String expression to be left-aligned within stringvar. 'varname1 Required. Variable name of the user-defined type being copied to. 'varname2 Required. Variable name of the user-defined type being copied from. End Sub -- Lamont Phemister "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
always need 32 characters
Was it necessary to multi-post???
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Hex Characters | Excel Worksheet Functions |