strip characters

  1. D

    Stripping characters using variable locations

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

    Excel 2010, data validation - strip - on peoples names obtained from sharepoint

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

    How do I strip out all non-numeric characters?

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

    Best way break apart Character String

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

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top