Stored numerical cells off by one [space]. RRS feed

  • Question

  • Out of long-term hope to save time, I search for a code snippet that sees an excel column of numbers and truncates all strings from the cell leaving only the numeric.

    ...  this is the type-cast

    Function SpaceRemove(Worksheet.Cells)
        minsp = Range("Cells")= String("numeric + space")
        sp = minsp - String(" ")
        Cast String sp as Variant
        Return (sp as Variant)
    End Function


    Just a novice ...  they say to not open the door

    • Edited by RefugioM Tuesday, April 4, 2017 8:03 AM
    Tuesday, April 4, 2017 7:45 AM