Removing " characters from value

[andrewb90]

Hello all,

I'm looking for a formula to remove a " from the very beginning and very end of a cell value. Any way to effectively do this?
My current cell value is

=Initial!C13

I need to do that but have the " removed from the cell value.

Thanks, Andrew

 

[Joe4]

Try:

=SUBSTITUTE(Initial!C13,"""","")

 

[andrewb90]

Awesome! thank you

 

[Joe4]

You are welcome!