turn name into gender in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1452861%22%20slang%3D%22en-US%22%3Eturn%20name%20into%20gender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1452861%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20if%20i've%20a%20column%20full%20of%20names%20(like%20James%20and%20Jane)%2C%20how%20can%20i%20create%20another%20column%20to%20turn%20these%20names%20into%20gender%20like%20male%20and%20female%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1452861%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1453158%22%20slang%3D%22en-US%22%3ERe%3A%20turn%20name%20into%20gender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1453158%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F694778%22%20target%3D%22_blank%22%3E%40tcteng712360%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfraid%20that's%20only%20manually%2C%20Excel%20has%20no%20idea%20about%20the%20genders.%20If%20there%20are%20many%20repeating%20names%2C%20you%20may%20create%20dict%20table%20which%20maps%20James%20on%20male%20and%20Jane%20on%20female%2C%20etc.%20After%20that%20VLOOKUP%20or%20INDEX%2FMATCH%20it%20to%20fill%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, if i've a column full of names (like James and Jane), how can i create another column to turn these names into gender like male and female? Thanks

1 Reply
Highlighted

@tcteng712360 

Afraid that's only manually, Excel has no idea about the genders. If there are many repeating names, you may create dict table which maps James on male and Jane on female, etc. After that VLOOKUP or INDEX/MATCH it to fill the data.