Thread: how do I insert a variable amount of blank spaces in a formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote