none
Stored numerical cells off by one [space].

    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


    RO

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

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

Answers