I am not new to Excel and cannot understand why I cannot find the answer to this problem.
I have a colleague who is trying to do a Find and Replace (actually a Find & Remove) and I cannot recreate the issue on my end to tell him why it's not happening the way he wants.
Sample of the cell values:
MAS0110 Total
MAS0111 Total
MAS0118 Total
MAS0119 Total
MAS0123 Total
MAS0125 Total
He wants to find " Total" and Replace with nothing. I trust his level of expertise and he has done this numerous times before and he gets the wanted results.
MAS0110
MAS0111
MAS0118
MAS0119
MAS0123
MAS0125
What is happening is that his search string is deleting the entire contents of his cells. He sent me the file, when I try it, mine works okay. We tried finding just "Total" (no leading space) and that works fine but leaves the trailing space. We could always trim the cell but at this point we want to know why this is happening now when it has not for him in the past.
I have tried taking the values of his cells into a text editor and it looks like a regular space character preceding "Total".
Now here's the weird thing. If I have him put just a "space" in the Find box, and then hit replace, it grabs the word "Total" along with it and gives him the desired results.
At this point I'm thinking it may be one of his settings but can't imagine where. Thanks for the help!
Bookmarks