Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: "scanning" a string in a cell?

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    houston, tx
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi, id like to write what is perhaps a custom function - and perhaps an existing function or macro - to scan a cell, character by character.

    for instance, the cell might contain:

    HAPPINESSVILLE 2880244-2378, RHUBARB

    i'd like to be able to delete everything but the number, and there are certain cases in which everything after the numbering starts AND before the comma should be retained.

    the heart of the matter is: im just trying to determine the simplest way to "scan" a string in a cell, character by character, and to implement simple conditionals based on that.

    thanks in advance,
    rs

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,657
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Care to give a bit more examples along with expected results?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •