View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debi Debi is offline
external usenet poster
 
Posts: 28
Default how do I remove leading spaces and leave the remianing spaces w

I am attempting to remove any leading spaces should there be any within a
range of cells
Example:

In Cell B16 " find the spaces"
in Cell B17 " Must leave other spaces"
In Cell B18 "May have no leading spaces"

The only spaces I would want to eliminate are the ones before "find...." and
"Must.."