Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help String functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - RPad function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - RPad

Syntax:
=RPad(Text, Length , FillWith )

Description:
Returns the string Text padded to the right with characters FillWith to the total length specified.

Text : string to pad
Length : target length of the padded string
FillWith : character used to fill the Text string to the required length

Example:
Print the word Title and right pad it with equal signs to a length of 25:
=RPad("Title",25,"=")

litLIB