Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Sep 2001
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula to Delete cell data? (English)

    I was wonder if this was possible. If I had a cell that had this data, "I_am_clueless", and I wanted to write a formula that only deletes "I" and "clueless", so that it leaves "am" in the cell, is it possible? Is it capable to have a formula that would delete the first 2 characters of the cell and the remainder after the 4th character?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Formula to Delete cell data? (English)

    You can do it by either Excel formula using combinations of =FIND(), =REPLACE(), =LEFT(), =RIGHT(), =MID, =LEN(), =TRIM()

    ... or by VBA using analogous Methods including Find, Replace, Left, Right, Mid, Len and other text Methods (they vary according to version). There several threads here in the VBA Forum on text manipulation and replacement.

    Can you provide more specifics on your objective? If you're looking for Excel formulas, post in the Excel Forum.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Lounger
    Join Date
    Sep 2001
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula to Delete cell data? (English)

    Thanks John!

  4. #4
    Lounger
    Join Date
    Sep 2001
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula to Delete cell data? (English)

    THANKS!

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formula to Delete cell data? (English)

    To expand on what John said and to specifically < delete the first 2 characters of the cell and the remainder after the 4th character > you could use, <pre>=MID(A1,3,2)</pre>

    which creates a string starting with the 3rd character of a string in A1 and takes 2 characters (the third and the fourth) from that point, which in your example would return am

    Andrew C

Posting Permissions

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