LinkBack URL
About LinkBacks
ringrim 
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 function
http://www.notverypc.org/
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
if(F1=IRRATIONAL,"F","M")
Last edited by JChandler22; 08-13-2008 at 05:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks