help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help 1
Substitute letters by others in a word 4
help needed 5
Help Please! Random generator issue. 2
Calculate Width of String, not Length? 'Em' not 'Kearning'? 2
Help with IF function 13
Help with OR function 6
Returning comlumn hearder uppon matching a text sting in a row 4

Back
Top