I am working on a sub procedure that will basically loop through a column of data of variable length, strip out the text from those cells, and place the remaining numbers/characters into a new column. I have everything worked out except I can't get a good code for stripping out the text and spaces and leave just the numbers and characters. An example value would be "100-150/300 some kind of text" where I want to leave just "100-150/300". The numbers/characters and text length change. Let me know if you need more information to help. Thank you.
Bookmarks