Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

Copper Contributor

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 :handshake:

2 Replies
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.

Hello

 

Only if it's for screen and print

 

Customize cells format number

[<2]"Male";"Female"

 

 

@emmanuel265