If you mean there is text in A2 (not A3) that you want to leave alone, then you can't have a static value in a cell and a formula at the same time. It would take VBA to do what you're asking.