If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help
if names r given to me which contain even letters like "bush" "boss" clay"
"wali" "walou".... how can i generate a formula that would lead to the first and third letter to be in capitals and rest small...... i know its a silly question but we have a silly teacher....... and can u plz also tell me the formula that would lead to the same result with odd number of letters |
#2
|
|||
|
|||
help
You'll most likely need these functions:
LEN MID UPPER LOWER ISEVEN ISODD Those are the pieces...now make the puzzle *********** Regards, Ron XL2002, WinXP-Pro "zomex" wrote: if names r given to me which contain even letters like "bush" "boss" clay" "wali" "walou".... how can i generate a formula that would lead to the first and third letter to be in capitals and rest small...... i know its a silly question but we have a silly teacher....... and can u plz also tell me the formula that would lead to the same result with odd number of letters |
Thread Tools | |
Display Modes | |
|
|