Function Rept()

Rept()

This function fills a cell with the given string repeated 'n' number of times


Syntax:

= Rept (Text , Number of Times)

Text = is the text or characters to be repeated
Number of Times = is the number of times the given text is to be repeated


Example:

= Rept ("M", 7) - result will be - MMMMMMM
= Rept ("E M", 3) - result will be - E ME ME M

Note: note the highglighted characters in the above examples. The number of characters to be removed and the number of new characters to be inserted may not be same. You can insert as many characters as you want in place of any number of characters from the string


Excel Matic Tip:

The Rept() function repeates a given character 'n' number of times and this number provided in the function can be used dynamically for other purposes, such as:

Make Graphic presentation of numeric data without using graphs:

  • In cell A1 to cell A10 write any numbers (try not to go beyond 50)
  • Now in cell B1 type this function:

    = Rept("l", a1)

  • The character I have used is present on your keyboards above the Return key. You would need to press SHIFT and then the key above return key
  • Now copy this function till range B10
The output you will get will be something like this:



The image above uses Rept() to create a bar graph with "l" symbol which represents the frequency given in column A




Share on Google Plus

About Nifty Guru

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Monday, June 8, 2009

Function Rept()

Rept()

This function fills a cell with the given string repeated 'n' number of times


Syntax:

= Rept (Text , Number of Times)

Text = is the text or characters to be repeated
Number of Times = is the number of times the given text is to be repeated


Example:

= Rept ("M", 7) - result will be - MMMMMMM
= Rept ("E M", 3) - result will be - E ME ME M

Note: note the highglighted characters in the above examples. The number of characters to be removed and the number of new characters to be inserted may not be same. You can insert as many characters as you want in place of any number of characters from the string


Excel Matic Tip:

The Rept() function repeates a given character 'n' number of times and this number provided in the function can be used dynamically for other purposes, such as:

Make Graphic presentation of numeric data without using graphs:

  • In cell A1 to cell A10 write any numbers (try not to go beyond 50)
  • Now in cell B1 type this function:

    = Rept("l", a1)

  • The character I have used is present on your keyboards above the Return key. You would need to press SHIFT and then the key above return key
  • Now copy this function till range B10
The output you will get will be something like this:



The image above uses Rept() to create a bar graph with "l" symbol which represents the frequency given in column A




Function Rept()SocialTwist Tell-a-Friend

0 comments:

Post a Comment