Excel 2013 | ||||
---|---|---|---|---|
A | B | |||
1 | "I am here] | "I am here" | ||
2 | james | james | ||
3 | "who am I | "who am I | ||
4 | "I need help] | "I need help" | ||
Sheet9 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =IF(AND(LEFT(A1,1)="""",RIGHT(A1,1)="]"),REPLACE(A1,LEN(A1),1,""""),A1) |
ok, got to ask, if i want to use the fomula on the row C, i replace all the A with C in formula?