Ask Your Question

Insert a given number in the middle of text.

asked 2017-05-17 22:58:56 +0200

Daanik gravatar image

updated 2017-05-17 23:01:30 +0200

Hi everyone!

I'm wondering if I can write "Amount in N transactions" so that N would be J3, for example. Where if I write 10 in J3 I end up with "Amount in 10 transactions".

The first thing I've tried was "Amount in J3 transactions" or "Amount in =J3 transactions", and as theres the possibility of my problem being a simple sintax trick I'm appealing to y'all.

Note that J3 not necessarily will be 10, my point is for it to work for any given real number.

And, if its possible, how would it be to make "Amount in N+1 transactions"?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2017-05-17 23:12:41 +0200

updated 2017-05-17 23:15:55 +0200

Two options:

  1. ="Amount in " & J3 & " transactions"
  2. Use cell formatting and set number format to something like "Amount in "# ##0,00" transactions"

The latter has an advantage that the cell value doesn't actually change, only is displayed with given decoration, and the cell may further be used in calculations.

edit flag offensive delete link more

answered 2017-05-17 23:19:48 +0200

Lupp gravatar image

updated 2017-05-17 23:23:59 +0200

Sorry! Post crossed the other answer.

(See the answer by @Mike Kaganski! )
="Amount in " & J3 + 1 & " transactions" e.g for the N+1 case if N is value of J3.
You can also explicitly define a format for the nuerical part using TEXT(J3+1;"000") e.g.
If you want the respective cell not only to display the compound string, but also to pass the numeric value if referenced, put =J3+1 as a formula into the cell, and define its 'Numbers' format as
"Amount in " General " transactions" .

edit flag offensive delete link more

answered 2017-05-17 23:38:25 +0200

Daanik gravatar image

Wow that was fast. Thank you very much guys. You have no idea how much I do appreciate it.

Unfortunately its only possible to mark one of the answers as the correct one, but in my heart both are marked! :D

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-05-17 22:58:56 +0200

Seen: 208 times

Last updated: May 17 '17