+ Reply to Thread
Results 1 to 2 of 2

Thread: DB problem: more records into a unique cell

  1. #1
    Registered User
    Join Date
    09-01-2011
    Location
    Rome, Italy
    MS-Off Ver
    Excel 2003
    Posts
    1

    DB problem: more records into a unique cell

    Hello everybody, I'lltry to explain my problem as good as possible.
    I need to create a database with excel for managing resumes. I have data, then I fill a db and automatically, according to particular criteria, the names of the potential candidates for a job position must appear.
    My problem is this. A person has either 0 or more than 1 job experience. But I have only one cell. Each experience has a duration.
    How can I put into only one cell more than one experience, and in another cell, the duration of each?
    Example

    NAME JOB EXPERIENCE DURATION
    MARCO ACCOUNTANT 1 YEAR
    MARKETING 2 YEARS
    I wanna select a person with an experience in marketing.

    Please help me!

  2. #2
    Forum Guru mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2007/2010
    Posts
    3,004

    Re: DB problem: more records into a unique cell

    Try hitting ALT ENTER to create a new line in a single cell.
    Martin

    Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.

    If my solution has saved you time and/or money, please consider donating to Cancer Research UK.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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.2.0