Inserting numeric cell value into cell containing text.

EHSMGR

New Member
Joined
Sep 12, 2017
Messages
1
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.
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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)
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top