Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
92
Views
Topic starter
Hi All,
I am receiving excel data in mail format, once i copied that data's again in excel summing formula not working showing error due to space in numeric. can any body tell me how to remove extra space in cell.
Posted : 16/05/2024 3:33 am
You cell content is imported as text and not as a sumber
Posted : 17/05/2024 1:55 am
The data is quite 'dirty'. Easiest to clean it up with Power Query. The attached file does just that. I've created some basic queries to give you an ideas on how you can approach such a problem.
Posted : 17/05/2024 3:34 am
