Remove 1 letter from a column

A Rose

Hi there,

I have a column that has a quote before every word in the column, each row has different words,

Any way to remove just the quote?

Anyone, Please help out.

Thank you!

Matt Johnson

Hi @A Rose

I think the formula below will do the trick. You would add a column, drop this formula in, copy the column, paste values over your existing column and then delete the newly added column. I hope that works for you. The "Primary Column" in the example below would be whatever column has your data in it.

=REPLACE([Primary Column]@row, 1, 1, "")