In A1 if you have the value try the below

=A1&REPT("*",10-LEN(A1))

If this post helps click Yes
---------------
Jacob Skaria


"tallguy2u" wrote:

I need to format general content aligned left cells to add spaces after the
content so that the general content and the spaces after that content are
equal to a specific number.

For example:
total = 10
content = x00xxx
cell value = x00xxx****
where the *'s indicate a space

The number of content characters may vary from 1 to 10 in the above example