Forum Discussion

Mahendrajain's avatar
Mahendrajain
Copper Contributor
Jul 09, 2021

Cannot calculate the Sum

Hi team,   I created a form where I need to capture the total time spent on each activity. However, on the file under the total time I see an extra symbol before the number (example: '6) due to thi...
excel
PReagan's avatar
PReagan
Bronze Contributor
Jul 09, 2021

Hello Mahendrajain,

 

You can Find and Replace the extra symbols with Ctrl + H:

Or, you can substitute extra symbols like ' with =SUBSTITUTE(A1,"'",""):

 

 

Resources