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
Maybe Aaron's kb entry will help:
http://vbaexpress.com/kb/getarticle.php?kb_id=946
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
that kb is definitely what i needed. thank you for your reply
The spreadsheet formula
=LEFT(A1&REPT("x",28), 28)
should do what you want
Posting Permissions
Reply With Quote
