Two results in a single cell with text

[tigfur]

Hello,

Is it possible to view two results of formulas (or perhaps directly two formulas) in a single cell?

example

I have two columns of numbers and i would like to combine them

1 5
1 3
1 4
2 2
3 1

in a third column i would like each cell for each row to show me the result as " 1 (5) " (Example of the first row)

is that possible?

instead of the brackets there could also be words, like " 1 and remaining 5 "

the 1 and 5 should be linked results of course.


Kinda like what "printf" does in c

[AliGW]

Try this:

=A1&" and remaining "&B2

[tigfur]

oh awesome that works, so text is separated by &? can i use this to put two formulas in one cell, i mean =A1 is basically a formula?
Now i just have to find how to write " & "

Thanks for the very fast and simple answer

[tigfur]

Conditional formatting doesnt seem to like this though, can i apply conditional formating to just one part of the cell (as in the first number) ?

i had a MIN and MAX function highlighting the numbers, can that be aplied when i add text in the cell?

or should i make a separate thread for that?

[AlKey]

Maybe this

1.

=A1&" "&"("&B1&")"

2.

=A1&"  and remaining "&B1

v	A	B	C	D	E
1	1	5		1 (5)	1 and remaining 5
2	1	3		1 (3)	1 and remaining 3
3	1	4		1 (4)	1 and remaining 4
4	2	2		2 (2)	2 and remaining 2
5	3	1		3 (1)	3 and remaining 1

[AlKey]

Unfortunately your request required string manipulation and may not be suitable for Conditional Formatting.

[tigfur]

Which... also means other functions are not able to grab this cells numbers either?

Good to know, it has to be a plain output cell then, ill make that work. Thanks!

(would be kinda cool if i could highlight it if the numbers were the same though) perhaps i can use CF on the source cells and let the CF color the output cells

EDIT: ah no, i cant :D