Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Concatenate Problem- Please help!!!!

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here is my dilemna:

    I have 4 columns of data. Each column represents a segment of a general ledger account number.
    The first column has about 54 rows, which represents the Fund. (5 characters)

    The second column is the Account, and there are 71 of those. (6 characters)

    The third column is the Program and there are 39. (3 characters)

    Lastly there is the Project column and there are 9 of them. (2 characters)

    So in essence I would like a formula that will generate all the accounts for me in this format:

    XXXXX.XXXXXX.XXX.XX
    54x71x39x9= 348,894 general ledger accounts

    In addition, in the column following each of the columns is a short description. I would like to do the same thing above with the descriptions in the following format:

    Fund descr-Account name-Program-Project

    I have been trying to do this using the Concatenate function but to no avail. Can someone please help me?

    Thanks
    Gil

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You may also feel free to email me any solution to this.

  3. #3
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    XXXXX.XXXXXX.XXX.XX
    54x71x39x9= 348,894 general ledger accounts
    You're not going to be able to get this in Excel, you're limited to 65,536 values.


    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK, granted that was the case, I would break this up into mini-projects,...thats if I had a way to actually merge each field into one GL account....

    any ideas?

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    San Ramon CA
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hrmmm...

    Excel might be a bit confining... have you considered Access? It doesn't have the data limit, and is also inherently 'shareable' (multiuser). The the data formats that you are proposing wouldn't be hard to implement as an Access form or report, but you would have to define each "thing" in Access beforehand (what makes up a Fund, an Account, a Program, and a Project, and how they all interrelate.)

    Access can also dump data to Excel if you need it to produce charts and do other data analysis tricks Access can't handle.

    unf. I can't go into the nuts and bolts here, you would have to seek out an Access help board for detailed answers.

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    although you cant go into the nuts and bolts, could you point me a little?

    How in Access would I set this up?

    Ultimately I would need the end product to be a csv text file, which I know is no problem for Access.

    Thanks for your reply

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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