5 Replies Latest reply on Jul 28, 2020 7:28 AM by Gaz in Oz

    Search and Replace - "whole word" with starting blank

    Peter2_1

      Example: I have some simple strings in my worksheet like "my great statement"

       

      When I want to

      • "search and replace" with
      • search for: "great statement"
      • Option: whole word
      • it works fine

       

      When I want to

      • "search and replace" with
      • search for: " great statement"  (with leading blank)
      • Option: whole word
      • it highlights nothing

       

      Why it does not accept the leading blank?