PDA

View Full Version : [SOLVED] How can I show (the content) two cells in one cell in Calc?

Gr8world
June 1st, 2009, 08:50 AM
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.

samden
June 1st, 2009, 09:56 AM
Try:

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

Gr8world
June 1st, 2009, 10:01 AM
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

Gr8world
June 1st, 2009, 10:36 AM
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?

Gr8world
June 1st, 2009, 11:28 AM
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?

gunksta
June 1st, 2009, 01:39 PM
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.

Gr8world
June 1st, 2009, 03:31 PM
You're genius, thanx.