+ Reply to Thread
Results 1 to 6 of 6

Removing '< ' symbols

  1. #1
    Registered User
    Join Date
    10-29-2009
    Location
    BC, Canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Removing '< ' symbols

    Hi,

    Question... I have a grid of numbers and I'm trying to remove all the numbers that have a less then sign and replace those cells with just the number.

    For example. <10 would become 10.

    Any suggestions would be greatly appreciated. Thanks!

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Removing '< ' symbols

    Ctrl+H, search for <, replace with nothing.

  3. #3
    Registered User
    Join Date
    10-29-2009
    Location
    BC, Canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Removing '< ' symbols

    it's the replace with nothing part that doesn't work.

    find <
    replace with: (just leaving it blank doesn't work.)

    what do I put in the replace with spot?

    Thanks,

  4. #4
    Registered User
    Join Date
    12-14-2007
    Posts
    25

    Re: Removing '< ' symbols

    Alt , E , F

    then

    click replace , enter < in the top box

    and leave the one underneath blank

    then hit replace or replace all


    Tom

  5. #5
    Registered User
    Join Date
    10-29-2009
    Location
    BC, Canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Removing '< ' symbols

    great thanks!

  6. #6
    Registered User
    Join Date
    10-29-2009
    Location
    BC, Canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Removing '< ' symbols

    Quote Originally Posted by stevedickin View Post
    it's the replace with nothing part that doesn't work.

    find <
    replace with: (just leaving it blank doesn't work.)

    what do I put in the replace with spot?

    Thanks,
    leaving it blank does work. I was hitting find all not replace all... thanks

+ 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