deleting currency symbols from a report in excel

gsealbe's Avatar

gsealbe

28 Jul, 2022 06:36 AM

I have produced an MD report and exported this to excel. However, as the MD report contains Currency symbols. , I cannot do any calculations in Excel as each cell contains a mixture of alpha and numeric data
I can laboriously remove the Alpha currency symbol in the excel report but am wondering if there is some way to bulk remove Alpfa currency symbols from my excel report?
Can anyone help?

  1. 1 Posted by Stuart Beesley ... on 28 Jul, 2022 06:47 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    In excel use the find and replace feature to remove the symbols.

    Or edit the currency in MD, remove the symbol, rerun report.

  2. System closed this discussion on 27 Oct, 2022 06:50 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

31 Jan, 2023 09:32 AM
31 Jan, 2023 08:51 AM
31 Jan, 2023 08:46 AM
31 Jan, 2023 08:40 AM
31 Jan, 2023 08:16 AM