Complete Excel Guide

You will find all the information regarding Excel.

Friday, 25 August 2017

REPT Function

REPT Function

This function repeats the given text for the specified number of times.

Syntax: REPT(text,number_times)

Example: =REPT("$",10)
Result: $$$$$$$$$$




Assignment:
1. Check the following formulas.
=REPT("text",3)
=REPT("%",5)
Posted by Unknown at 12:04
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: excel formula rept, formula to replicate a text, how to replicate text in excel, rept () formula, rept formula in excel, rept function

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Archive

  • ▼  2017 (37)
    • ►  September (8)
    • ▼  August (29)
      • NOW & TODAY Functions
      • TIME Function
      • DATE Function
      • Date & Time Functions List
      • TEXT Function
      • SUBSTITUTE Function
      • REPLACE Function
      • MID Function
      • PROPER Function
      • FIXED Function
      • T Function
      • SEARCH Function
      • REPT Function
      • RIGHT Function
      • TRIM Function
      • UPPER Function
      • LOWER Function
      • LEFT Function
      • LEN Function
      • Find Function
      • EXACT Function
      • DOLLAR Function
      • CONCATENATE Function
      • CODE Function
      • CLEAN Function
      • CHAR Function
      • BAHTTEXT Function
      • Text Functions
      • Types of Functions in ExcelText Function  Date ...
Hit Counter
Ethereal theme. Powered by Blogger.