Fill cells with certain number of characters

[huorsa]

Is there a way to fill cell with certain number of characters.

Per example in cell A1 I want to fill it with 60 characters I don't care if they are numbers or letter. In cell A2 I want 20 characters, in cell A3 I want 8 characters.

I have many cells that I need to fill; so do you know a quick way of doing this.

Thanks

 

[IML]

look at the rept funciton that has two arguments.

=rept(text,# of times)

 

[Norie]

Is it any particular characters?

Have you looked at the REPT worksheet function?