Hi Mr. Richard, I guess, incase I change the 50 to 20, the REPT() function would only replicate the text in the given string 20 times, correct ? In this case, my last word should only be a maximum of 50 characters, I reckon.
No I think REPT will accept a lot bigger numbers than that. The reason why you might not want to do this is that Excel is creating a new string 9with all the spaces) in memory and this takes resources and thus time. To keep things running smoothly and quickly you should just use a reasonable number (which I figured to be 50).