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

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