Thread: What formula is needed to return the number of spaces indented?
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 What formula is needed to return the number of spaces indented?
How did you do the indenting?

If you just typed leading spaces...
=search(left(trim(a1),1),a1)-1




INDENT wrote:

--

Dave Peterson
Reply With QuoteReply With Quote