[Solved] Convert cell addresses from text to its values

[gazzlowe]

I have a text containing multiple cell addresses ( formula function several times substituted to get appropriate math syntax ) and I need each cell address to be replaced with its value without need to manually put every text into quotes and place amps between each text block / cell address.

[FJCC]

An example document would help us understand better what you are looking for. To upload a document, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.

It might also help if you would explain the higher level goal you are trying to achieve. There may be a simpler way to achieve it.

[gazzlowe]

Sorry for bad english, it's not my native language and my skills are quite bad, since I barely happen to express something in it.

[Villeroy]

=INDIRECT("A1") returns the value of the cell that is specified by the string "A1"

[MrProgrammer]

I have a text containing multiple cell addresses ( formula function several times substituted to get appropriate math syntax ) and I need each cell address to be replaced with its value without need to manually put every text into quotes and place amps between each text block / cell address.

201808131908.ods

(21.87 KiB) Downloaded 91 times

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.