Forum Discussion

emmanuel265's avatar
emmanuel265
Copper Contributor
Mar 16, 2023

What formula will translate 1 to "Male" and 2 for "Female"?

Hello guys,

 

I have this huge list of names on my excel spreadsheet with gender identification as 1 representing Male and 2 for female, but then it is supposed to be written Male and Female instead of putting a number for male or female. 

 

Is there any formula i can use to autimatically change the numbers to words please instead of manually changing that 1,000 plus list of names?

 

Thanks in advance 🤝

Formulas and Functions
  • Venkata Adusumilly's avatar
    Venkata Adusumilly
    Copper Contributor
    Mar 16, 2023
    Automatically - Yes; when you open a workbook through VBA you can change 1s and 2s in specific column of sheet to whatever you wanted.
    Alternatively; run a formula in next column (=IF(B2=1,"Male",IF(B2=2,"Female","Gender Not Found"))) and hide the column which says 1 and 2.

Resources