special characters

I am using the following UDF to remove all special characters Function RemoveSpecialCharacters(s As String) With CreateObject("vbscript.regexp") .Pattern = "[^A-Z0-9_\- /&]" .IgnoreCase = True .Global = True RemoveSpecialCharacters = .Replace(s, "") End With End Function But I...

Hello, I have an excel file consisting of about 50 worksheets which contain raw data. About 10 of them have names prefixed with a ^ sign. For example: ^Sheet3, ^Sheet4 etc. The remaining 40 sheets are named without any special prefixes. In the summary worksheet, I have a column with the...

Hello, I'm new here, but I have reviewed dozens of responses regarding the title of this post. Unfortunately, I haven't been able to get the results I desire. I am looking for numbers that appear after a special character, I only want to retain those numbers and I want to separate them with a...

Under Excel Options, Proofing, Auto Correct Options, I cannot enter the special character for the small triangle used to denote "delta". Any ideas? I getting tired of selecting symbols all the time. Thanks Tom

This seems easy enough but has turned out to be hard nut to crack. I'm tweaking a form built in Excel 2010. User inputs their name in cell L61, and the name of their show in cell L64. The value for these two cells gets concatenated to become the file name. All works great until they enter < >...

I know we all have our way of naming functions, subs and variables. But why don't we use special characters in the procedure-names? Like: MyFunctionName§() or MyCopyrightSub©() or even ¿test_MyFunctionName() It has his advantages! Procedures starting with one can be alphabetical above...

Hello, Our translation department has somehow managed to grab some of our data from the internet, paste it in excel, and have all the multilingual characters show up as their respective character codes. Is there an easy way to convert these back to their special characters? (é, à, è.....) An...

Hi Folks, -- I am pulling my hair out. I have an excel file that has the following in a cell: <tbody> 15005~40450~STDREG07~40452~STDREG81~05989001~12102003~33083002~11939004 I need to extract these values surrounding the tilde (~). Does anybody have any bright ideas? I really...

Hi, I have a macro in an excel spreadsheet that imports a csv file into an access table via ado. The csv is a download from sap and has 44 fields. One of the fields (Col34) in the csv is a free text. One day someone entered in sap - "Shipping 45 " OD - special loading" and this became a value...

Hello, I would like to insert some j apanese characters into vba but when I insert the characters I get: ?? Is it possible to have asian characters in the vba code? thanks C11

Hi Everyone! I dont understand why this code doesn't work. Can anybody help me please? I want to replace character numbers 1 - 31 with a space. The code below results in all my data being replaced by a space (so essentially it deletes my data). Sub Replace_Characters_One_To_ThirtyOne() Dim...

I haven't been able to figure this one out yet. I have searched many forum posts but cannot find the answer. I did not create the spreadsheet I am currently working on so I have formatting from PDFs and the internet jumbled into one. I am working on a vba routine to parse my text fields and...

In coulumn C, the value is a text which contains Starting with 2 digit alphabets, separated by ONE special character "/" or "-", then 4 to 8 digit numericals then again separated by ONE special character "/" or "-", then 2 to 3 digit numericals. Output required in column D = All text without...

I am using a simple SQL UPDATE statement to store userform textbox data into a database. The problem is that when a user types in the character " ' " or " \ " the data is not stored into the database. I don't receive an error it simply does not store the data. I thought it might be an...

Anyone know how to search for a Single Quote (') character in a cell? This is the character excel uses to indicate text formatting, and somehow I have a lot of cells with just ' in them that I need to remove. A Control-Arrow search for the start/end of a contiguous range finds them but find and...

I need to add trademark and registered trademark ASCII characters to a DBFIII database. The DBF file gets opened in Excel. An ASCII code (alt+0153 for trademark) is inserted and displays correctly. But, when the file is saved and re-opened, the 'TM' is a question mark. What combination of keys...

I am trying to do a Vlookup with a string that has the | (pipe) and ~ (tilde) characters in it. Vlookup doesn't appear to recognize or be able to do a match on these character. My string looks something like this - 112|a3457|lmpop|~|~ And yes, I do need all these elements. I've formatted...

The Macro I made requires 2 open workbook. 1st workbook is where it will automatically be filled up based on the contents of the 2nd workbook. The macro will ask the name of the 2nd workbook then after clicking "ok", the 1st workbook will be filled with the data. the name of the workbook is...

I've seen lots of help on how to disallow special characters when using data validation but nothing on how to ALLOW special characters. I have a pretty big spreadsheet that I'm working on that will be pushing the limits of data validation :). I'm really trying my best not to change the names...

I have spreadsheets generated from an online database. The site exports special characters as html strings--i.e., ö in place of ö,