LinkBack URL
About LinkBacks
Does anyone know how to do this. Or indeed if its possible. Thanks,
Does anyone know how to do this. Or indeed if its possible. Thanks,
well
=LEFT(A1,FIND(" ",A1)-1)&LOWER(MID(A1,FIND(" ",A1),255))
doG day AFTERNOON to
doG day afternoon
BUT
=LEFT(A1,FIND(" ",A1&" ")-1)&LOWER(MID(A1,FIND(" ",A1&" "),255))
WILL also work when only one word in cell
Last edited by martindwilson; 01-14-2014 at 08:38 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
=left(a1,find(" ",a1,1))&lower(substitute(a1,left(a1,find(" ",a1,1)),""))
?
Thank you yudlugar... however the limit with that one is that the first word, which is entirely in capital letters... remains entirely in capital letters... instead of just the first lettter...still its very nice. Any chance it can be perfected?
=proper(LEFT(A1,FIND(" ",A1&" ")-1))&LOWER(MID(A1,FIND(" ",A1&" "),255))
WILL also work when only one word in cell
Upper(left(a1,1))&lower(mid(a1,2,1000))
Yulugar that's perfect thanks very much
Why not one more
=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
AlKey, thank you, is there anything better about your one?
Thanks
LOL. It rocks! Just trying to give you more choicesOriginally Posted by davidx
You have a wonderful day
haha thanks, you have a great day too!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks