speacial characters

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...

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...

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 =...

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...