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
[Solved] Take text from one cell and use it in text in another cell
-
- Posts: 6
- Joined: Sun May 14, 2017 8:56 pm
[Solved] Take text from one cell and use it in text in another cell
Last edited by dervish_mcdroid on Sat Apr 13, 2024 6:05 pm, edited 2 times in total.
Apache_OpenOffice_4.1.3_Win_x86_install_en-GB Win 7 Ultimate
Re: Calc - Take text from one cell and use it in text in another cell
In C4
= "Deposit @"&Text(J2;"0")&"%"
= "Deposit @"&Text(J2;"0")&"%"
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 6
- Joined: Sun May 14, 2017 8:56 pm
Re: Calc - Take text from one cell and use it in text in another cell
Perfect. Many thanks. Marked as solved
Apache_OpenOffice_4.1.3_Win_x86_install_en-GB Win 7 Ultimate