dukun13210
12-19-2008, 05:33 PM
hi all,
I have a column that i need to modify:
i need to loop through all the values in the column and ensure that if the length of the string in each cell is not 28 then i need to pad it to the right with "x." if the length of the string is longer than 28 then i need to reduce it to be no longer than 28.
any help will be much appreciated; thanks in advance
I have a column that i need to modify:
i need to loop through all the values in the column and ensure that if the length of the string in each cell is not 28 then i need to pad it to the right with "x." if the length of the string is longer than 28 then i need to reduce it to be no longer than 28.
any help will be much appreciated; thanks in advance