1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2007

Discussion in 'Business Applications' started by chanshe112, Aug 8, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. chanshe112

    chanshe112 Thread Starter

    Joined:
    Aug 8, 2012
    Messages:
    5
    Hello Guys,

    I am a new user, I have a notepad with all the data I want to paste this data in excel with the correct information required in the particular cell. Please guys help I am suppose to submit by Friday.

    Regards,
    chanshe112
     

    Attached Files:

  2. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    67,489
    What is your question? Sorta defeats the purpose of homework to do all the work for someone else, eh? ;)

    and welcome to TSG. :)
     
  3. chanshe112

    chanshe112 Thread Starter

    Joined:
    Aug 8, 2012
    Messages:
    5
    Hello

    My question is there a formula or any kind of function which I can use to do this work. I want 4 characters in the first column which is sr. no, 4 in title, 8 in first name, 2 in middle name, 15 in last name, 19 in company job title, not more than 15 in address so on and so forth.

    Regards,
    Shekar
     
  4. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    67,489
    I'm certain that there is, but again, we generally don't assist with homework. It defeats the purpose of learning the formula. I'm assuming this is for school, correct?
     
  5. chanshe112

    chanshe112 Thread Starter

    Joined:
    Aug 8, 2012
    Messages:
    5
    No Vilas this is just a sample of the work load which I am going to get it in my office I want to learn the formula. If you can please help me.
     
  6. WendyM

    WendyM Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,032
    If this is actual data, you've just posted a ton of people's personal information on this website, which I doubt they'd appreciate. You should probably delete that txt file from your post.
     
  7. chanshe112

    chanshe112 Thread Starter

    Joined:
    Aug 8, 2012
    Messages:
    5
    These are fake database, wendy, I am sure that they will not mind. But still I will take your suggestion and delete it once I get a solution for it.
     
  8. GeorgeJ

    GeorgeJ

    Joined:
    Jan 16, 2012
    Messages:
    144
    This is going to sound really strange, but i think it will do the job.

    When i open the txt file, it opens in notepad.
    Ctrl+A (to select all) and copy (Ctrl+C)
    Open Wordpad (in accessories folder)
    paste into wordpad (Ctrl+V)
    copy from Wordpad (Ctrl+A, Ctrl+C)
    open Word
    paste into Word (Ctrl+V)
    Find & Replace (Ctrl+H)

    tricky part here is adding the tab characters
    click on the 'More...' button and click Special - select tab character.
    Select and Copy this character (Ctrl+C)
    In FIND put 2 spaces
    In replace, paste the tab character (Ctrl+V)
    click replace all

    now to get rid of the extra tabs
    in find delete anything in there and paste in 2 tab characters
    (keep just the one in replace)
    click replace all and continue until there are no replacements

    Select all and copy
    paste into excel

    There may be some data with an extra space character at the start or front - will this be a problem? If so, you could try using some clean formulas =clean(A1)

    Hope this is of use.
     
  9. chanshe112

    chanshe112 Thread Starter

    Joined:
    Aug 8, 2012
    Messages:
    5
    Thank you GeorgeJ, It did help me in some extent but not completely I will paste a sample of it

    3001 Dr. Apolonia Joe Saskatoon.
    Saskatoon. SK Canada 3063820241

    now this is the data, what I want to do is, I want to assign or specify this data to a specific cell for example
    Sr. no. is of 4 characters, it should accept only 4, I am able to do it with with data validation but the tricky part comes with the company job title and the address in it.

    So if any one can help that would be appreciated.
     
  10. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1064304