Sep 18 2023 12:33 AM - edited Sep 18 2023 12:35 AM
In the attached screenshot "I want the total to show as 20 but it is only calculating numbers"
Sep 18 2023 01:01 AM - edited Sep 18 2023 01:01 AM
@Rehanparkar I would not recommend capturing data like that, but if you have Excel365 or 2021, this would work:
Sep 18 2023 01:04 AM
Sep 18 2023 01:13 AM
@Rehanparkar I would just separate the texts from the numbers. That is, each in their own cells. Something like this:
Sep 18 2023 01:19 AM