Hello

My problem is when I download data from Accounting Software to Excel.
The data is in British Pounds, and when downloaded to Excel each number has
a symbol attached to it (e.g. ｣414.90). With this symbol in front of each
number, I am unable to perform forumlas on the data (Excel is not accepting
the data as numerical). I need a way of removing the symbol from each
number.

I can delete the symbol manually from each number, however, it is a long
process.

Is there a function in Excel that removes a symbol?

Any help would be appreciated

Regards,

Bernard Purdon