Results 1 to 7 of 7

Thread: excel help

  1. #1
    Senior Member
    Philquad's Avatar
    Join Date
    Jan 2008
    Location
    nelson bay
    Age
    55
    Posts
    3,872
    Thanks
    192
    Thanked 1,305 Times in 783 Posts
    Rep Power
    665
    Reputation
    16938

    Default excel help

    anyone know if you can open this text file so that in excel each field in a seperate cell
    surname - mobile - email im after

    https://www.facebook.com/philquad68



Look Here ->
  • #2
    Banned

    Join Date
    Feb 2012
    Posts
    2,361
    Thanks
    166
    Thanked 1,205 Times in 607 Posts
    Rep Power
    0
    Reputation
    16611

    Default

    ?

  • #3
    Senior Member

    Join Date
    Oct 2009
    Posts
    2,742
    Thanks
    2,501
    Thanked 2,295 Times in 850 Posts
    Rep Power
    995
    Reputation
    36415

    Default

    Flick me you email Phil and I'll show you what I've done

    Last edited by Seymour Butts; 30-09-14 at 06:51 PM.
    In hindsight I should have posted my Facebook status as: "I've blown the head gasket on my 1997 XR3i" rather than "I've just buggered a 14 year old escort".
    The police still haven't seen the funny side, my lap top's been confiscated and the wife has gone off to her mum's.

  • #4
    LSemmens
    lsemmens's Avatar
    Join Date
    Dec 2011
    Location
    Rural South OZ
    Posts
    10,585
    Thanks
    11,868
    Thanked 7,061 Times in 3,338 Posts
    Rep Power
    3153
    Reputation
    132592

    Default

    Excel should just import it correctly if it is a csv. You might have to change the extension to filename.csv.

  • The Following User Says Thank You to lsemmens For This Useful Post:

    Seymour Butts (30-09-14)

  • #5
    Senior Member

    Join Date
    Oct 2009
    Posts
    2,742
    Thanks
    2,501
    Thanked 2,295 Times in 850 Posts
    Rep Power
    995
    Reputation
    36415

    Default

    That's exactly the way I did it.
    Save the txt file as a csv then open in excel, on save as xlsx.
    The problem is you lose all the leading zeros on the phone numbers as soon as you open it in excel.
    You can overcome this by inserting a ' in front of the leading zero - but it's a bit of annoying editing.
    Cheers
    In hindsight I should have posted my Facebook status as: "I've blown the head gasket on my 1997 XR3i" rather than "I've just buggered a 14 year old escort".
    The police still haven't seen the funny side, my lap top's been confiscated and the wife has gone off to her mum's.

  • #6
    Senior Member
    Philquad's Avatar
    Join Date
    Jan 2008
    Location
    nelson bay
    Age
    55
    Posts
    3,872
    Thanks
    192
    Thanked 1,305 Times in 783 Posts
    Rep Power
    665
    Reputation
    16938

    Default

    i got it
    the old missing zero trick
    i changed the cell format to text instead of number
    that fixes it
    https://www.facebook.com/philquad68

  • #7
    Premium Member
    Al Bundy's Avatar
    Join Date
    Jan 2008
    Location
    Tazzie
    Posts
    4,480
    Thanks
    2,005
    Thanked 5,194 Times in 1,906 Posts
    Rep Power
    2204
    Reputation
    92870

    Default

    Phil, an alternative would have been to set the cell format by selecting the "Number" tab, then selecting "Custom" under Category, then under "Type:" enter 10 zeros and any spaces you may want to include;

    Cheers
    Ted (Al)

  • 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
    •