strip characters

I found a function on this site that will strip the characters from a string and just leave the numbers. I would like to use variables as the object of the function. My current macro is finding different areas of my spreadsheet that I need to strip off unwanted characters. What I would like...

I am trying to validate user names against another report. In my current excel report I have names obtained from a sharepoint name select. such as MCCARTHY, Sam;#1100;#JOKIL, Ricke;#1346;#OMARA, Jill;#4111 these are all contained within one cell. If I attempt to use Text to columns, it is...

How do I strip out all non-numeric characters? I have 10,000 phone numbers, of which people entered in different formats, such as 212.123.1234 212 123 1234 212-123-1234 (212)123-1234 How do I strip out ALL the data/characters that are NOT numbers so the result is 2121231234 I want all...

Hi guys, Here is my problem. I have a .csv file that has thousands of entries of car makes, models, year etc. Unfortunately my customer has given me the file from their DB and each entry with all the data is in a SINGLE CELL for each record. I need to break apart each of these and place them...