+ Reply to Thread
Results 1 to 4 of 4

removing firsts two numbers from a list of #s

  1. #1
    Linny51
    Guest

    removing firsts two numbers from a list of #s

    I have a large list of numbers that are, as an example, 20-13-240. I want to
    remove the first "20" from each number. Is there a quick way of doing that?

    thanks!

  2. #2
    JulieD
    Guest

    Re: removing firsts two numbers from a list of #s

    Hi

    one option,
    (on a backup copy of your workbook)

    select the data and choose
    data / text to columns
    choose
    fixed width and press next
    click on the preview bit after the 20
    so you have
    20|-13-240
    where the | is the line drawn in by excel
    click next
    then for the
    20
    choose "do not import"
    click in the -13-240 bit
    and choose "text"
    click FINISH

    Cheers
    JulieD

    "Linny51" <Linny51@discussions.microsoft.com> wrote in message
    news:1A848EDE-01C2-4CFB-840D-8C864E429EF2@microsoft.com...
    >I have a large list of numbers that are, as an example, 20-13-240. I want
    >to
    > remove the first "20" from each number. Is there a quick way of doing
    > that?
    >
    > thanks!




  3. #3
    Linny51
    Guest

    RE: removing firsts two numbers from a list of #s

    Oh duh, Julie ! I can't believe I forgot this! Thanks so much!

    "Linny51" wrote:

    > I have a large list of numbers that are, as an example, 20-13-240. I want to
    > remove the first "20" from each number. Is there a quick way of doing that?
    >
    > thanks!


  4. #4
    JulieD
    Guest

    Re: removing firsts two numbers from a list of #s

    Hi Linny

    easy to do (forget that is!)

    have fun
    JulieD

    "Linny51" <Linny51@discussions.microsoft.com> wrote in message
    news:6C427F4F-3B53-45BC-B818-E12B8B508C09@microsoft.com...
    > Oh duh, Julie ! I can't believe I forgot this! Thanks so much!
    >
    > "Linny51" wrote:
    >
    >> I have a large list of numbers that are, as an example, 20-13-240. I
    >> want to
    >> remove the first "20" from each number. Is there a quick way of doing
    >> that?
    >>
    >> 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