Isolating each letter in a word string in Excel?

Question

I have a long list of names and I wish to perform a function on each name that would make the first character in the string a capital letter, how could I do this using Excel. For example: smith, would be Smith. Normally, I can just use some text delimiter like a comma or a space to parse the word out, it in this instance I need to isolate a particular charater in a string. I'm wondering is there is a way to put each character in a column, then I could make may change and then just "&" the word back together. Any suggestions?

Answer 1

Assuming the string you wanted to deal with was in cell A1, this formula entered in a different cell would capitalise the first character of it:

=UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)-1)

Answer 2

Does this Help:
http://h20271.www2.hp.com/SMB-AP/cacche/319615-0-0-190-121.html

Answer 3

Just using cell formulas?
If your text is in cell A1, then here is your formula
=UPPER(MID(A1,1,1))&MID(A1,2,LEN(A1))

Hope that helps. Would be better to write this in VBA.

Answer 4

arts, ante, aids, duet, duel, deaf, useless, deal, pricey, deed, dude, boring, dune, deer, dine, dire, dial, daft, dais, dart, darn, date, dole, executed, dare,ease, east, eats, fade, fist, experience, positive, feat, ft, feud, gas, fond, fund, furl, fried, fend, fart, citadel, quickly, document, hearth, agonize, fail, fuse, idea, idle, laid lane, lain, land, very last,lend, existence, record, lead, leaf, lord, left, loft, lust, lest, nest, want, note, neat, rind, rend, rebellion, rift, real, rude, ruse, reef, roar, raft, redo, rote, relax, reported, sear, seat,deliver, seal, section, leap, type, bitter, sore, threat-free, sate, real, have a tendency, tore, tote, tort, tiff, tide, tire, informed, tree, teal, tart, music, turf, tail

Answer 5

=PROPER(A1)
yaHoO will be Yahoo
yahoo will be Yahoo
YAHOO will be Yahoo
yAHOOo will be Yahoo
Yahoo will be Yahoo