special character

  1. T

    SaveAs VBA Removing Special Characters

    Hello, I have the following code which names a sheet after a specified cell and then copies into a new workbook. The next stage attempts to save the workbook after another cell value however this is where I became stuck. Cell D2 can contain special characters so the save as isn't working...
  2. C

    Getting special characters to save within a CSV

    When I export my XLSM sheet to a CSV I have a special character that turns from the character Φ in the XLSM to a ? in the CSV I have tried saving the sheet as CSV then going into Tools->Web Options->Encoding-> and selecting Unicode (UTF-8) but is still turns this character into a ? when I open...
  3. S

    Data Validation

    Hey i want to Validated a Cell with Only some text. Means the cell only accept some text which i want Like XS-S-M-L And so on The cell which i validated should not accept anything else then that. Can anyone here who can help me out with this Issue.?????:confused::confused::confused::confused:
  4. I

    How to Remove Square Character?

    Hello, The special character I'm referencing won't appear in my post when I paste the Excel data as HTML. It essentially looks like a larger version of the square special character in the symbol library. When I click on the cell, the formula bar displays the square with a question mark in it...
  5. Y

    Mailto hyperlinks *sometimes* break with # usage

    I'm using Excel 2016 on Windows 7 Enterprise. My team works with virtually every department in the company, so we keep a resource guide with mailto links for every point of contact. The mailto's include copies of relevant managers AND my team's distribution group. The distro group address is...
  6. R

    Return string after return character

    Ok, I have a bunch of address entries, unfortunately the address and city, state, zip are all in one cell and I need to make them 2 or 3 Here's what the data looks like currently <tbody> 123 Main St. Anytown, AB 11111 123 Main St. Anytown, AB 11111 </tbody> This is what it needs to look...

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