ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software»
  • Office Software Suites»
  • Microsoft Office

Process to convert first letter of every word of a cell in capital letters in Microsoft Excel

Updated on June 19, 2013

Have you ever had to make entry or edit entries of names or locations in a spreadsheet which requires to keep the first letter of each of the words as capital letters. For example, if there is a long list of names of customers or employees; think the names were entered in a hurry and many of the parts of the names do not have a capital first letter. Now you have to finalize the spreadsheet and make sure the data will be stored in a proper format. It would be a tiring process to edit all name cells one by one and if it’s a long list it might be near to impossible. Here I will show you an easy way to solve this problem in seconds. Let’s get started.

Get yourself ready

To do the process we have to use a computer which has Microsoft Excel installed in it. Here I am using Microsoft Excel 2010 to show you the process. Moreover, the process has been shown on a prepared Excel file of HR department of an imaginary firm.

Steps to Process to convert first letter of every word of a cell in capital letters

Step 1: Select the Column Next to Name Column. In this case it is the Department column. Doing so, the whole column will be shown in a light blue appearance.

Step 2: Right Click on the Column and Select the Insert option from the list appeared.

Inserting Column next to Employee name
Inserting Column next to Employee name

Step 3: Type down the same Field Title as in a cell aligned of the previous column

Insert the same field name
Insert the same field name

Step 4: Select the first cell under the field.

Step 5: Click on the Formula tab from the Excel Ribbon.

Step 6: Click on the Text option from the Function Library of the Formula Toolbar.

Step 7: Select PROPER from appeared the drop down list.

Select PROPER function for the cell
Select PROPER function for the cell

Step 8: When the Function Argument box appears, Click on the first cell with the Name in previous column and Click on OK.

Selecting the cell for the function to use
Selecting the cell for the function to use

Step 9: Automatically all the parts of the Name will have capital letter at the beginning. Now Double Click on the Lower Left Corner of the cell to execute the function in all the following cells of the range.

Double click on lower left corner to execute the function in that range
Double click on lower left corner to execute the function in that range

Step 10: Now, Select all the cells you just have executed the formula on and then Copy them.

Copy all the cells where the function has been executed
Copy all the cells where the function has been executed

Step 11: Right Click on the same range and Select Paste Value from the Paste Special option.

Paste Value on the same selected cells
Paste Value on the same selected cells

Step 12: Now Right Click on the previous column with the improper name format and then Select Delete option from the Menu.

Delete the Previous Column with improper name format
Delete the Previous Column with improper name format

How the process works

The PROPER function is the function to convert the first letter of every word of the reference cells to capital letters. Moreover, in the last steps- where we copied and pasted the value in the cells, we smartly replaced the result of the function only with the output values, so when we deleted the previous column- it did not affect the data of the new column at all.

Think More

Do not delete the previous column before you copy and paste the value in the new column. Otherwise the whole new column will be useless.

Comments

    0 of 8192 characters used
    Post Comment

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: "https://hubpages.com/privacy-policy#gdpr"

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized. (Privacy Policy)
    CloudflareThis is used to quickly and efficiently deliver files such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisements has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)