ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   help (https://www.excelbanter.com/excel-worksheet-functions/62970-help.html)

zomex

help
 
guys how can i generate a formula that would lead to even number letters
like"bush" "clay" "boss" "sale" "cout" to have capital letter of first and
third letter and rest smalls..... can u plz also tell me abt the formula that
would lead to the same result but contains odd numer of letters........ i
know that its a silly question but we have a nincompoop for a teacher

JulieD

help
 
Hi

mmm, not really into doing other people's homework (and i don't think it's
such a bad exercise), so here's a few cluse for you:

with your word in A1

=MOD(LEN(A1),2)
will tell you whether it is "even" or "odd"

=UPPER(LEFT(A1,1))
will extract and capitalise the first letter of the word

=UPPER(MID(A1,3,1))
will extract and capitalise the third letter of the word)

=MID(A1,2,1)
will extract the second letter of the word

=RIGHT(A1,LEN(A1)-3)
will extract the remaining letters of the word

the & can be used for joining things together, such as
=A1 & B1

now, if you put all the above info together you'll have your answer :)

have fun
--
JulieD

julied at hctsReMoVeThIs dot net dot au


"zomex" wrote:

guys how can i generate a formula that would lead to even number letters
like"bush" "clay" "boss" "sale" "cout" to have capital letter of first and
third letter and rest smalls..... can u plz also tell me abt the formula that
would lead to the same result but contains odd numer of letters........ i
know that its a silly question but we have a nincompoop for a teacher



All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com