Spreadsheet in Microsoft Excel.
I am interested in changing all the text in a particular column to lower case, then change only the first character in each field cell to upper case. Example: "GREG" to "Greg"
What I have is a spreadsheet with inconsistant text case in each field cell of data (some all lowercase, some all uppercase, some mixed). I am trying to clean it up and make it consistant. I am working with several thousand rows and about a dozen columns with all different text entries...
Currently I am having to go in and re-type each entry. I would like to write a macro which would look at the cell text, change it all to lowercase, then change the first character to uppercase. Then repeat this function thruout the entire column.
Any help would be greatly appreciated.
Thanks,
Greg
2006-10-19 10:39:58 · 4 answers · asked by Greg B 1 in Computers & Internet ➔ Programming & Design
Use the PROPER() fuction
E.g.
If your text is in cell B2, and your target cell is C2:
In the C2 forumla, you'd put: =PROPER(B2)
2006-10-19 10:47:26 · answer #1 · answered by freddrick_flintstone 3 · 0⤊ 0⤋
Use the right functionality. in the adventure that your information is in col A, In B1 style =appropriate(A1) ... and drag this down col B. you will now could "restoration" col B. decide on the finished column by ability of clicking on the letter B. Now replica (Ctrl-C), then on the menu decide on Edit->Paste particular, values. you are able to now delete col A.
2016-10-02 11:36:47 · answer #2 · answered by ? 4 · 0⤊ 0⤋
I think all you have to do is highlight the whole top bar and "format" "font". Choose lower case and it should change all to lower case.
Hope that helps.
2006-10-19 10:48:14 · answer #3 · answered by phy333 6 · 0⤊ 0⤋
=PROPER(A2) if you put that into a cell you get the text in cell A2 in the format you want
2006-10-19 10:49:47 · answer #4 · answered by tru_story 4 · 0⤊ 0⤋