M MonitorOntario Dec 26, 2003 #1 How can I convert an entire column of capitalized text to proper. How d I apply the the "proper" formula to the text in the cell
How can I convert an entire column of capitalized text to proper. How d I apply the the "proper" formula to the text in the cell
D Dave Peterson Dec 26, 2003 #2 You could use a helper column and put a bunch of formulas like: =proper(A1) and drag down the column. Or you could use a macro: David McRitchie has sample code at: http://www.mvps.org/dmcritchie/excel/proper.htm And if you're new to macros, David has some getstarted instructions: http://www.mvps.org/dmcritchie/excel/getstarted.htm
You could use a helper column and put a bunch of formulas like: =proper(A1) and drag down the column. Or you could use a macro: David McRitchie has sample code at: http://www.mvps.org/dmcritchie/excel/proper.htm And if you're new to macros, David has some getstarted instructions: http://www.mvps.org/dmcritchie/excel/getstarted.htm
