Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    copying numbers (XP)

    Merry Christmas to you all..
    I'm having a blonde moment. I have done this before but for the life of me can't remember how I did it..
    In column B I have info that looks like this 006 - Paris or 007 - Amsterdam.
    In column A I only want the 3 numbers, and I can't remember the formula to do that. I know its pretty simple.

    Thanks for the help

    Cheers

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: copying numbers (XP)

    Try

    =Left(B1,3)

    Enjoy
    Jerry

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: copying numbers (XP)

    I knew it was simple [img]/forums/images/smilies/smile.gif[/img]
    Thanks heaps

Posting Permissions

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