View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ctal[_2_] Ctal[_2_] is offline
external usenet poster
 
Posts: 2
Default How can I query the 'indent' level of text in a cell?

How about
Len(yourcell) - Trim(yourcell)

The result would be the number of leading spaces provided you have no
other irregular spacing in the cell.