Results 1 to 7 of 7

Thread: How can I show (the content) two cells in one cell in Calc?

  1. #1
    Join Date
    Mar 2009
    Beans
    25

    How can I show (the content) two cells in one cell in Calc?

    Ok, I hope this is possible...
    So what I want is to show the content of two cells in one (after each other). I mean something like this:
    if I have two cells: 24
    25
    and what I want to do is to put some kind of formula in an other cell to get this : 2425

    Is this possible? Someone knows how to do this?

    And one more thing... It has to be with formula because I have to make a lot of such cells and it is impossible to put it in manually.



    Thanx for reading

  2. #2
    Join Date
    Nov 2006
    Location
    New Zealand
    Beans
    417
    Distro
    Ubuntu 10.04 Lucid Lynx

    Re: How can I show (the content) two cells in one cell in Calc?

    Try:
    Code:
    =CONCATENATE(A1,B1)
    That is a text command however and you end up with "2425" written as text, not recognised as a number. I am not sure what to do if you want to do further calculations with that number.
    IBM ThinkCentre 8142 - Ubuntu 10.04
    Acer emachines D620 - Ubuntu 9.04

  3. #3
    Join Date
    Mar 2009
    Beans
    25

    Re: How can I show (the content) two cells in one cell in Calc?

    Yes, it did it! Thanx, and no, I don't have do anything with it later, I just have to store it like that.

    thanx

  4. #4
    Join Date
    Mar 2009
    Beans
    25

    Re: How can I show (the content) two cells in one cell in Calc?

    Damn, it doesnt work after all...

    If I want to drag it and assume that it will recognize and do the same thing, it doesnt. Well here is what I did:
    I had 'n' (n is a regular number) numbers in A1, A2, A3, A4,...,An
    and I wanted to make A1A1 in B1, A1A2 in B2, A1A3 in B3,... so I did =CONCATENATE(A1,A1:An). And it works, but it works only if I put it in manually because when drag e.g. From B1,B2,B3 (already filled in) to e.g. B7
    then it doesn't do the right thing, but gives me something like A4A4, A4A5,A4A6, A4A7.

    Is there a way to make it work how I want it to work?

  5. #5
    Join Date
    Mar 2009
    Beans
    25

    Re: How can I show (the content) two cells in one cell in Calc?

    Ok, maybe another question....
    Is there a way to copy-paste into a selection of cells?
    for exampple if I select 1000 cells and I put there =CONCATENATE(A1,A1:A1000)
    It will work but how can I put this in several cells at once?

  6. #6
    Join Date
    Oct 2005
    Location
    Albany, NY
    Beans
    828
    Distro
    Ubuntu

    Re: How can I show (the content) two cells in one cell in Calc?

    Quote Originally Posted by Gr8world View Post
    Damn, it doesnt work after all...

    If I want to drag it and assume that it will recognize and do the same thing, it doesnt. Well here is what I did:
    I had 'n' (n is a regular number) numbers in A1, A2, A3, A4,...,An
    and I wanted to make A1A1 in B1, A1A2 in B2, A1A3 in B3,... so I did =CONCATENATE(A1,A1:An). And it works, but it works only if I put it in manually because when drag e.g. From B1,B2,B3 (already filled in) to e.g. B7
    then it doesn't do the right thing, but gives me something like A4A4, A4A5,A4A6, A4A7.

    Is there a way to make it work how I want it to work?

    In your first cell, B1, try this. =CONCATENATE($A$1,A1:An)

    Now drag. It should work. $ lets you freeze a cell reference in a formula. $A freezes the column while $1 freezes the row.
    Please Insert Funny Statement Here.

  7. #7
    Join Date
    Mar 2009
    Beans
    25

    Re: How can I show (the content) two cells in one cell in Calc?

    You're genius, thanx.

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
  •