Previous Topic Next Topic

TEXT TO NUMBER

Closed
TOM - Aug 3, 2009 at 04:29 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 3, 2009 at 08:38 PM
Hello,
CELL A1 COULD BE TOM OR JIM
I WANT CELL B1 TO = 1 FOR TOM AND 2 FOR JIM

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 3, 2009 at 08:38 PM
=IF(A1="Tom",1,IF(A1="jim",2,""))

this is formula in B1
0