how do I insert a variable amount of blank spaces in a formula?
 

I am trying to insert a number of spaces into a cell depending on how many
characters I have in another cell. Does anyone have any idea how I would do
that?

Thanks

how do I insert a variable amount of blank spaces in a formula?
 

Maybe...

=rept(" ",len(a1))


Lucy4484 wrote:

I am trying to insert a number of spaces into a cell depending on how many
characters I have in another cell. Does anyone have any idea how I would do
that?

Thanks

--

Dave Peterson