[Solved] Take text from one cell and use it in text in another cell

dervish_mcdroid · Post by **dervish_mcdroid** » Sat Apr 13, 2024 3:40 pm

SOLVED
Hi.

I have one cell (J2) that I manually enter a numeric value.

I have another cell (C4) that has text, into which I wish to insert the number entered in J2 into

so (J2) is 25
(C4) is Deposit @25%

I want is so that when I change the value in (J2) to 50, (C4) becomes Deposit is 50%
All and any advice gratefully received

Win 10
OpenOffice
AOO413m1(Build:9783) - Rev. 1761381
2016-09-29 02:39:19

Many Thanks

Post by **Zizi64** » Sat Apr 13, 2024 5:43 pm

In C4
= "Deposit @"&Text(J2;"0")&"%"

dervish_mcdroid · Post by **dervish_mcdroid** » Sat Apr 13, 2024 6:03 pm

Perfect. Many thanks. Marked as solved

[Solved] Take text from one cell and use it in text in another cell

[Solved] Take text from one cell and use it in text in another cell

Re: Calc - Take text from one cell and use it in text in another cell

Re: Calc - Take text from one cell and use it in text in another cell