-H (Opens find & replace)
Enter &[:space:] in find what
click OK
Worked GREAT yesterday!
Enter ^[:space:] in find what
Click OK
Worked GREAT yesterday
Won’t work today, even after shutdown and re-open the document.
Any ideas?
TNX,
⌡im
-H (Opens find & replace)
Enter &[:space:] in find what
click OK
Worked GREAT yesterday!
Enter ^[:space:] in find what
Click OK
Worked GREAT yesterday
Won’t work today, even after shutdown and re-open the document.
Any ideas?
TNX,
⌡im
What does “won’t work” mean? Is there a message? Did you enable regular expressions in the search?
Regular expressions is ticked.
&[:space:] will not locate a space at the end of a cell (neither will $[:space:])
^[:space:] will not find a space at the end of a paragraph
Replace box in empty
Opened a fresh instance of the file this AM
Same thing.
4500 cells, almost instantly worked yesterday on the 100 I had formatted … YES I know there are spaces at the beginning and end of some newly formatted cells.
Thanks again, ⌡im
You might have swapped fields, although its hard to tell as you apparently entered both expressions in Find. From List of Regular Expressions:
& Adds the string that was found by the search criteria in the Find box to the term in the Replace box when you make a replacement.
In other words, & belongs in the Replace box. Or did you want &
(&space) in the Replace box?
Otherwise, make sure Regular Expressions is ticked