I have a sheet with a formula in col. B to put some text based on text typed in col. A.

10% of the time the text in col. B won't be accurate in which case I just type in the accurate text and it overwrites the formula. Works great and saves time from manually entering the text in col B 90% of the time.

The problem is when I have to either change the formula in Col. B or delete the entry in col. A the formula is still gone. This especially creates a headache when I want to change the formula in B and drag down but I have to skip the rows where data was manually entered. There are 1000+ rows.

Any suggestions for a way to still have the text automatically fill col B based on formula but allow you to manually overwrite without removing the underlying formula?

The current solution I'm toying with is to have a 3rd column, C, where you can manually enter text when you need to overwrite and then the formula in col B starts with =if(c1<>"",c1,....). But this is messy and the habit is always to just put the new text in col B.

I would be grateful for a more elegant solution.

Thanks!

Shawn