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 this, I'm not able to sum the calculation via the Pivot table.

 

Please help me in resolving this issue.

 

Thank you,

Mahendra

excel

1 Reply

  • 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