Home
Microsoft Office Excel 2007 Tutorial
Introduction
Editing
Format Style
Table
Chart
Formula
Workbook Worksheet
Wordart Clip Art Shape Picture
PivotTable PivotChart
Data Analysis
Macro ActiveX Add in
Security
Collaboration
Database functions
Date Time functions
Engineering functions
Information functions
Logical functions
Lookup Reference functions
Math Trigonometry functions
Statistical functions
Text functions
REPT « Text functions « Microsoft Office Excel 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Text functions
REPT
22.18.REPT
22.18.1.
REPT(text,number_times) repeats text a given number of times
22.18.2.
Pad the number with asterisks on the left
22.18.3.
Display asterisk padding on both sides of the number
22.18.4.
Display the value along with the asterisk padding on the left:
22.18.5.
Pad the number with dashes
22.18.6.
To pad the number with asterisks, use two asterisks