capitalized

  1. J

    Capitilization After Special Character

    Hi, I have made a code where if I were to write out a name in a textbox the first letter will be capitalized. It also capitalizes the first letter whenever I add a space between names. So, I am having this problem where whenever I put a special character or a number (For ex...
    • JarekM
    • Thread
    • capitalized character letter space special
    • Replies: 6
    • Forum: Excel Questions
  2. A

    Capitalized File Extension???? Why and How to Change from ".XLSX" to ".xlsx"

    I have an excel file that is saved with a capitalized extension, "XLSX". I've tried to resave the file with a lowercase "xlsx" extension, but I am unable to do so. I've checked in the options and settings, and searched online for an explanation, but have had no luck. Can anyone tell me when and...
  3. S

    Flip LASTNAME and Firstname where LASTNAME is always capitalized

    Data in column A. I want to split the data to 3 columns and flip the lastname with firstname. Lastname is ALWAYS capitalized. When firstname or/and lastname consists of 2 words then it can be in 1 cell. Look for example (2 BERNAL Egan Arley) beneath. Any help is appreciated. Data to change...
  4. M

    Separating text when someone inputted the middle initial with the last name.

    Help... I've done something like this before where I had a names entered in to the same cell, but they always had spaces between the first and last or first, middle, last. This time around I'm looking at 15,000 entries where it's a capitalized middle initial immediately followed by the...
  5. L

    Use of =PROPER in Excel workbook

    I just figured out that this existed (=PROPER to change fields that are capitalized, so that the first letter of each word is capitalized), yay! But am having the dumbest issue with it: my workbook displays the formula, not the result. :confused:
    • Lisacpa
    • Thread
    • =proper capitalized formula results proper workbook
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top