Inserting numeric cell value into cell containing text.

[EHSMGR]

Good morning,

I am working on a LOTO project. I have a cell with the location of my circuit breaker that has the following contents:
23, 25, 27. This circuit breaker information is located in cell E2 of my spreadsheet. The cell I would like to insert E2's contents into has the following text:

[TABLE="width: 454"]
<tbody>[TR]
[TD]Move Breaker 35 to the off position. This breaker is located in the electrical room panel in Setter Hall 3. It is labeled LS-3. Apply the breaker lock-out device. Next, close and lock the panel door.[/TD]
[/TR]
</tbody>[/TABLE]

The text above is located in cell AF2. The cells are located in the same spreadsheet.

I would like to be able to use a formula to replace the 35 so that the contents of E2 would appear. The cell would then display:

[TABLE="width: 454"]
<tbody>[TR]
[TD]Move Breakers 23, 25, 27 to the off position. This breaker is located in the electrical room panel in Setter Hall 3. It is labeled LS-3. Apply the breaker lock-out device. Next, close and lock the panel door.[/TD]
[/TR]
</tbody>[/TABLE]

Thank you for your help.

 

[frank_AL]

The SUBSTITUTE Function can probably give you the result you are looking for.

If 35 is a fixed value and assuming the text string is in cell B2 and the string you want to place in that string is in B3 you could use this formula: =SUBSTITUTE(B2,"35",B3)

If 35 is a value in a cell (B1 in my formula)and again assuming the text string is in cell B2 and the string you want to place in that string is in B3 you could use this formula: =SUBSTITUTE(B2,B1,B3)