speacial characters

  1. sdkorin

    Count SUMPRODUCT Match and a second criteria

    Greeting! I'm trying to figure out how to count a specific group of people in a workbook. My workbook is for staffing and name populate out of another workbook with specific character formatting (special characters are attached to the name specifying gender and certifications) Generally peoples...
  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. L

    Character error when using MSXML2

    I'm having a problem downloading data when the website uses foreign or special characters. In this case "Rübæus" Here is my code: Dim xmlhttp As New MSXML2.XMLHTTP50 Dim text1 As String xmlhttp.Open "GET", "http://beeradvocate.com/beer/profile/1199/23474", False xmlhttp.send text1 =...
  4. F

    Delete row starting with an asterix

    I am trying to write a macro that would delete a row if the first character in column A is an asterisk. None of my attempts work. (using the left function in VBA and searching for ~*) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> When I search for an...

Watch MrExcel Video

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