+ Reply to Thread
Results 1 to 4 of 4

Deleting inside the cell

  1. #1
    Registered User
    Join Date
    12-22-2010
    Location
    Slovakia
    MS-Off Ver
    Excel 2010
    Posts
    20

    Deleting inside the cell

    Hi,

    how can i delete choosen symbols inside the cell..? For example.. i have a number 1111 444 inside a cell. How can i set the cell to delete 1111 and leave only 444..? Is there a macro or a formula for that..? I tried to use Find-Replace, but no luck.
    Thx

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Deleting inside the cell

    And what is the problem with Find-Replace? Works OK for me ( maybe there are options that need to be changed in the Find replace window)

  3. #3
    Registered User
    Join Date
    12-22-2010
    Location
    Slovakia
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Deleting inside the cell

    Hmmm.. possibly.
    How would you delete "1111" from cell, where the full number is 1111 4444..? I somehow cant figure that one out...

    Thx

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Deleting inside the cell

    Ctrl + H -
    Find what 1111
    replace with ( leave blank)
    Click "replace" or "replace all"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1