Remove 1 letter from a column

A Rose
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
    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, "")

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner