Brandonfromsingapore
New Member
- Joined
- Jan 5, 2012
- Messages
- 38
Hello Forum,
I know there is a non-macro to do this and it is rather simple but i was hoping to see if i can also incorporate this into a macro?
I have an excel workbook with several sheets.
I need the following to be done on the active sheet
In this sheets, the header is on row 1
On the header that says “First Name” and “Middle Name(s)” and “Last Name”
I need the data in the rows below these header to be Proper (=proper(). This needs to be done on all the applicable rows until the last row with data (the number of rows is not fixed)
The problem that I face now is that I often get wrong capitalisation of the names. Sometimes they are in all caps, sometimes they are in all small alphabets. It is really kinda messy. I was hoping for a macro to do this and then I can assign the shortcut of “Ctrl” + “e”
Thank you
I know there is a non-macro to do this and it is rather simple but i was hoping to see if i can also incorporate this into a macro?
I have an excel workbook with several sheets.
I need the following to be done on the active sheet
In this sheets, the header is on row 1
On the header that says “First Name” and “Middle Name(s)” and “Last Name”
I need the data in the rows below these header to be Proper (=proper(). This needs to be done on all the applicable rows until the last row with data (the number of rows is not fixed)
The problem that I face now is that I often get wrong capitalisation of the names. Sometimes they are in all caps, sometimes they are in all small alphabets. It is really kinda messy. I was hoping for a macro to do this and then I can assign the shortcut of “Ctrl” + “e”
Thank you