PDA

View Full Version : Solved: string concatenation



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

lucas
12-19-2008, 05:43 PM
Maybe Aaron's kb entry will help:

http://vbaexpress.com/kb/getarticle.php?kb_id=946

dukun13210
12-19-2008, 06:04 PM
that kb is definitely what i needed. thank you for your reply :)

mikerickson
12-19-2008, 10:38 PM
The spreadsheet formula

=LEFT(A1&REPT("x",28), 28)

should do what you want