I would like to use formula by ignoring letters attached to numbers in cells.

Copper Contributor

I would like to use divide formula between cells but my numbers in my cells has like $ sign or ''Ct.'' letters next to numbers. what should i write into formula to get rid of the letters or signs which is next to numbers and make excel get just number and make the calculation ?

1 Reply

It depends. If you have cells with applied currency format, you shall do nothing, values are numbers. Did you try to do any ariphmetic with your cells?