Results 1 to 5 of 5

Thread: How to delete number that contains dash sign (Help required)

  1. #1
    imrank is offline Senior Member+
    Last Online
    28th May 2016 @ 01:28 PM
    Join Date
    27 Jun 2009
    Posts
    423
    Threads
    43
    Credits
    1,040
    Thanked
    16

    Default How to delete number that contains dash sign (Help required)

    Assalam-o-alaikum!
    I am using excel 2010. I have an excel sheet in which character and numbers are mentioned in one cell per raw and the data is in thousands of raws. Following is the example of few: -

    A A BBBBB CCCC 012354-2 1,283,228
    D D YYYY 066666-1 3,749
    Y Y MMMMM 123564-5 175,095
    BBBBBB UUUUU 2356489-7 5,192

    I want to remove all numbers that contain "-" sign. Like I want to remove 012354-2, 066666-1, 123564-5 and 2356489-7 but I want to keep character with abc and numbers mentioned with ,. like 1,283,228, 3,749, 175,095 and 5,192. I want data to appear as under: -

    A A BBBBB CCCC 1,283,228
    D D YYYY 3,749
    Y Y MMMMM 175,095
    BBBBBB UUUUU 5,192

    Could you please advise how I can do it? Is there any find and replace command, which finds number with dash sign and removes it on entire sheet?

  2. #2
    imrank is offline Senior Member+
    Last Online
    28th May 2016 @ 01:28 PM
    Join Date
    27 Jun 2009
    Posts
    423
    Threads
    43
    Credits
    1,040
    Thanked
    16

    Default

    Still no replies? Is it that difficult? I would appreciate, if an answer is given today.

  3. #3
    hameesa.khan is offline Senior Member+
    Last Online
    22nd June 2016 @ 11:54 PM
    Join Date
    27 May 2016
    Location
    Karachi
    Age
    25
    Gender
    Male
    Posts
    64
    Threads
    0
    Credits
    406
    Thanked: 1

    Default

    Ap InStr(string1, string2) ka function use kar k check karein.
    Started programming when I was 12.
    Software Developer, Mobile Application Development.

  4. #4
    imrank is offline Senior Member+
    Last Online
    28th May 2016 @ 01:28 PM
    Join Date
    27 Jun 2009
    Posts
    423
    Threads
    43
    Credits
    1,040
    Thanked
    16

    Default

    I have version 2013 not 2010. It was typo. I don't konw about string1, string2 function. Please elaborate.

  5. #5
    imrank is offline Senior Member+
    Last Online
    28th May 2016 @ 01:28 PM
    Join Date
    27 Jun 2009
    Posts
    423
    Threads
    43
    Credits
    1,040
    Thanked
    16

    Default

    i don't know*

Similar Threads

  1. Solved Contects number not delete plz hlp me
    By Asfand4U in forum Solved Problem (Mobile)
    Replies: 8
    Last Post: 22nd April 2015, 03:17 PM
  2. Sim se Delete Number..???
    By Sweet Abbas in forum Mobile phones problems and Help Zone
    Replies: 0
    Last Post: 13th April 2012, 10:26 PM
  3. Glow Number delete
    By atif3001 in forum Mobile phones problems and Help Zone
    Replies: 2
    Last Post: 20th January 2011, 08:07 PM
  4. Replies: 1
    Last Post: 8th May 2010, 08:12 PM

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
  •