printable

  1. L

    Removing Non Printable Hex Characters

    Is there a formula that can be used to remove printable hexadecimal characters from a cell? It appears that CLEAN only removes non printable characters. I am trying to load data into a business system from an excel template and it is erroring on Hex characters so I was hoping there was an easy...
  2. H

    Advancing Columns by Week

    Hello All, I am honestly not sure if this is possible in Excel, but I will throw it out there anyway in case someone has some thoughts! I would like to create a spreadsheet that will be used to keep track of information by week (i.e., week 1 data, week 2 data, etc.) over the course of a year...
  3. L

    typing non printable characters

    Hi I want to learn how to clean excel file from all none wanted characters. So I want to type these characters first and then learn how to use formulas etc to remove them. I want to know how to type these none printable characters in excel. I read the article below, it says that char(127) but...

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