Clara - sounds like the repeat function would work for you. For example,

=REPT("A",7)

would return seven A's ("AAAAAAA"). Alternatively, you might also find the
Text function useful for aligning numbers:

=TEXT(1,"0000")

would return "0001".

Hope this helps.

-Cory

"clara" wrote:

Hi all,

Is there a function which can insert a fixed number of character. I want to
use this kind of function to do the alignment.

Clara
--
thank you so much for your help