Hello,

I have text in one cell such as 1. Trial 2 B . I have been using the MID function to pull out the first character and turn it into a percentage (=MID(A1,1,1)*1), and I get 10 displayed in a different cell. Is there a way to add a second formula into the same cell, that'll check what the contents are, and if they are ever "0", will replace them with "100"? Or can I embed it somehow into the MID formula?

Thank you very much!

PsychGirl