I have a large spreadsheet with a number of cells containing text that have a "*" character at the end. I would like to find and replace this character and delete it. This solution doesn't seem to work in Excel 2010.
How to find and replace a "*" character in a cell without deleting the entire contents in Excel 2010
Asked
Active
Viewed 8,153 times
-2
-
1It should work that way. See http://stackoverflow.com/questions/20631723/how-to-remove-the-character-in-excel-2010 – SΛLVΘ Nov 10 '15 at 10:01
-
Apologies. It does work. It was my pesky Danish keyboard! – Howeitzer Nov 10 '15 at 10:01
-
Feel free to remove the post. – Howeitzer Nov 10 '15 at 11:06
2 Answers
0
I think you need something like:
=SUBSTITUTE(RANGE,"*","")
You could definitely put a cell range in there, such as:
=SUBSTITUTE(A1:Z2000,"*","")
And I suspect you could put a worksheet name in there?
David Vernon
- 866
- 4
- 11
0
Use the Replace function by pressing CTRL + H and searching for ~* replacing with a blank.
Wool
- 68
- 1
- 9
-
Looks like a duplicate of http://stackoverflow.com/questions/20631723/how-to-remove-the-character-in-excel-2010 ? – Wool Nov 10 '15 at 10:06