ExcelBanter - Imbedding Cell into a Label

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Imbedding Cell into a Label (https://www.excelbanter.com/excel-discussion-misc-queries/47977-imbedding-cell-into-label.html)

Raymond Gallegos

Imbedding Cell into a Label

Hello. Does anyone know if (or how) it is possible to imbed a cell
reference into a label. For example:
A1: = 20%
A10: = "You own (a1) of the fund"

Result in A10: "You own 20% of the fund"

I would greatly appreciate anyone's assistance. Thank you.

David Billigmeier

In A10:

=CONCATENATE("You own ",A1," of the fund")

--
Regards,
Dave

"Raymond Gallegos" wrote:

Hello. Does anyone know if (or how) it is possible to imbed a cell
reference into a label. For example:
A1: = 20%
A10: = "You own (a1) of the fund"

Result in A10: "You own 20% of the fund"

I would greatly appreciate anyone's assistance. Thank you.

Dave Peterson

="you own " & text(a1,"0.00%") & " of the fund"

Raymond Gallegos wrote:

Hello. Does anyone know if (or how) it is possible to imbed a cell
reference into a label. For example:
A1: = 20%
A10: = "You own (a1) of the fund"

Result in A10: "You own 20% of the fund"

I would greatly appreciate anyone's assistance. Thank you.

--

Dave Peterson

All times are GMT +1. The time now is 10:56 PM.