Forum Discussion
Add Letter Into Number
I am wanting to see if there is a way to have a letter inserted into a cell that already has a number if another cell meets a certain criteria. See below for example. Cells in Column D are prefilled...
Adding a letter to an existing cell is not allowed in a functional programming language such as the Excel formula language. Conditional formatting changes the way in which a number is displayed without changing the underlying number. Other than that, you will need an imperative programming language such as VBA. A Worksheet Change Event would be able to read column D and replace it with something else because state changes are an integral part of such languages.