formatting text

  1. X

    export in text and functionality

    Good afternoon I have an extract of data that i wish to filter/search etc, however the driver is the date which is in a text format. I have tried unsuccessfully to alter the format of the date but i always seem draw a blank. The data looks something like this '01/12/2010 13:45:08' Can...
  2. Fa.Fa

    Help A Sistah Out!!! - Formatting Cell --> Day of Week

    SHORT VERSION: I have a column for date of draft depending on date of load. I want to be able to have the DRAFT date automatically filed after entering the date LONG VERSION: So I started helping out at a fuel company and I was bragging about being good at excel. I didn't know nearly as much...
  3. J

    Format texts within a cell

    As far as I know, it's possible to format the text within a cell to the user's liking. For example, if in cell A1 there is the following text: 'My name is Sam' Then the user is free to set My to red, name to blue and bold, and Sam to underlined, etc. I have a workbook. On the same sheet...
  4. M

    funny squares in excel

    I have converted a data base to excel and in a lot of the text in the address column are small boxes. I guess these are from dashes or unknown characters in the text. Is there any way to get rid of them other than doing it manually. Quentin
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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
Top