Good Afternoon,
I have a row on my sheet F with values that say either Male or Female. How do i change it to just say F if female or M if Male. Sorry to be such a noob.
Im hoping this is really easy.
Good Afternoon,
I have a row on my sheet F with values that say either Male or Female. How do i change it to just say F if female or M if Male. Sorry to be such a noob.
Im hoping this is really easy.
Two very simple methods attached:
gender.xls
ringrim,
Please read the Forum Rules about thread titles before starting your next thread.
you need the Notverypc addin
then use the IRRATIONAL functionPlease Login or Register to view this content.
if(IRRATIONAL(F1),"F","M")
Last edited by martindwilson; 08-13-2008 at 05:37 PM.
You could just use Edit > Replace
First Replace Female with F and then Male with M
Hahaha even better.Originally Posted by martindwilson
Last edited by JChandler22; 08-13-2008 at 05:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks