Forum Discussion

jharris1993's avatar
jharris1993
Copper Contributor
Mar 20, 2025

Excel 2021: Replace value in one cell based on the values of two cells (that cell and one other)

Greetings:

I am using Excel to normalize some foreign-language bank data for my taxes. (Excel, and Notepad++ are excellent tools for data-conversion tasks!)

Given the following data truth table

 

Column A      Column B
   [null]              [null]         <== no change
   !=null            [anything]  <== no change
   [null]             !=null         <== Column A should change to "XFR"

 

In other words, if column B is not null, and column A is null, then column A should become the text "XFR"

How do I implement this?

excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 21, 2025

    This cannot be done with a formula in column A.

    One option would be to return the desired values in a third column, for example in column C.

    In C1:

    =IF(OR(A1<>"", B1=""), A1, "XFR")

    To change the values in column A itself would require VBA.

Resources