Macro to strip text from cell.

**ntsun** · 09-24-2014, 09:41 AM

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.

**nathansav** · 09-24-2014, 09:48 AM

for i=1 to len(strCellContents)
    if isnumeric(mid(strCellContents,i,1) or mid(strCellContents,i,1)="/" then
        strOutput=strOutput & mid(strCellContents,i,1) 
   end if
next i

then use strOutput

**ntsun** · 09-24-2014, 10:15 AM

Thank you again for the quick reply. With some slight tweaking that got me what I needed.

Macro to strip text from cell.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro to strip text from cell.

Re: Macro to strip text from cell.

Re: Macro to strip text from cell.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to strip out items in text file and paste into columns

[SOLVED] How do I strip punctuation from end of text?

How to strip text from a cell

Strip text in cell

Strip text before character

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions