| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
convert weekday string to number
Is there an easy way to convert a string which is either "Monday" thru
"Sunday" into a number to work with? In particular, I want to add a 1 if the cell contains "Monday", 2 if "Tuesday" etc. Any ideas? Thanks! |
|
#2
|
|||
|
|||
|
Have a look in HELP index for LOOKUP
-- Don Guillett SalesAid Software "nico" wrote in message ... Is there an easy way to convert a string which is either "Monday" thru "Sunday" into a number to work with? In particular, I want to add a 1 if the cell contains "Monday", 2 if "Tuesday" etc. Any ideas? Thanks! |
|
#3
|
|||
|
|||
|
=LOOKUP(A1,{"Friday",5;"Monday",1;"Saturday",6;"Su nday",7;"Thursday",4;"Tues
day",2;"Wednesday",3}) Vaya con Dios, Chuck, CABGx3 "nico" wrote in message ... Is there an easy way to convert a string which is either "Monday" thru "Sunday" into a number to work with? In particular, I want to add a 1 if the cell contains "Monday", 2 if "Tuesday" etc. Any ideas? Thanks! |
|
#4
|
|||
|
|||
|
=MATCH(A1,{"Monday","Tuesday","Wednesday","Thursda y","Friday","Saturday","Su
nday"},0) -- HTH Bob Phillips "nico" wrote in message ... Is there an easy way to convert a string which is either "Monday" thru "Sunday" into a number to work with? In particular, I want to add a 1 if the cell contains "Monday", 2 if "Tuesday" etc. Any ideas? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to COnvert text string to number | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| Excell deletes 0 when its the first number in a string | Excel Discussion (Misc queries) | |||
| how can i convert a number in words? | Excel Discussion (Misc queries) | |||
| count number of occurences within a string | Excel Worksheet Functions | |||
Hybrid Mode
