How to get rid of dollar symbols

[bschwartz]

Hello,

The issue I am having comes from copying and pasting values from my online bank statement. I have a running balance that I copied to Excel for analysis. Excel cannot calculate formulas using these numbers since there is a $ symbol attached to each cell that was copied and pasted and the values do not seem to be recognized by Excel as numbers. Do you have any solution or ideas pertaining to this, or do I need to manually remove those symbols to enable calculation?

Excel version: 2010
Formula I tried to enter in cell F3: =F2-D3+E3
See example via link below.

Your help is greatly appreciated.

(sorry if this the wrong way to post a picture, but I could not figure out how else to attach or incorporate it into the post).
https://docs.google.com/document/d/1RM6Ywu0Aht0n_AozpXVbc8T4LybvqTl2OH-LtIBYYhQ/edit

Ben

 

[Peter_SSs]

Are both of those "blank spaces" at the end CHAR(160)?
If so, you could see if this approach is any use.

Select one of the cells in question
In the formula bar select one of the "blank spaces" at the end and press Ctrl+C (Copy).
Select the whole Debit & Credit columns by click/drag their column labels
Use Find/Replace and in the Find what box Ctrl+V (Paste) to paste one of the Char(160) characters
In the Find/Replace dialog, check in Options that "Match entire cell contents" is NOT checked
Replace All