Problem description: Points in a text comma want change, change ALL comma. Steps to reproduce: 1. Example: I type in a cell: Hello.hola.example.boat 2. Find and Replace (ctrl+alt+b) 3. Replace: dot (.) Comma (,) (and press botton "Replace all") Current behavior: The result is: ,,,,,,,,,,,,,,,,,,,,,,, Expected behavior: The result should be: Hello,hola,example,boat Operating System: Ubuntu Version: 4.0.3.3 release Last worked in: 4.0.0.3 release
Hi Casimiro, In the Find & Replace dialog, select Fewer Options and uncheck Regular expressions. "dot" in regular expressions means "any single character". That's why you get this result. Have a nice day, Jacques Guilleron