Thread: RPad Function Help

I've been trying to pad cells in Excel and found a formula that seemed to work with a program called litLIB that popped up from googling this.

the formula was =RPAD("string",padlength,"padcharacter")

I have a spreadsheet with about 20 columns and I was hoping this formula could cross over into another worksheet

I tried something like =RPad(worksheetA.xls!$A$1,25," ") and that seems to be fine for one cell, but I cannot seem to copy it down the column as in =RPad(test.xls!$A$2, 25," ") =RPad(test.xls!$A$3,25," ") etc... automatically, instead I am stuck changing it for each one and I have about 3,000 rows.

Can I create a range from the first worksheet and place it in this formula? I've tried defining a range but I can't figure out exactly how to place it in the formula to get it to work.

Thanks for the help

Thank you, that worked nicely

A follow-up q, when I pad a cell and then save it as a .txt(tab delimited) file and then open it up in notepad, it's adding tabs in between the cells. Any idea how I can not have this happen? Would be a great help.

Thanks