How to change cell value down one column into another but change the row value?

debugcn Published at Dev

d0pamine

    <figure>
  <img src="https://laptopscreenz.com/wp-content/uploads/156-WUXGA-40PIN-FHD.jpg" title="=(B3)" alt="=(B3)" "longdesc="=(B3)">
  <figcaption>=(B3)</figcaption>
</figure>
<figure>
  <img src="https://laptopscreenz.com/wp-content/uploads/156-WUXGA-40PIN-FHD-2.jpg" title="Innolux BT156GW02 V.0 Laptop LCD Screen Replacement 15.6" alt="Innolux BT156GW02 V.0 Laptop LCD Screen Replacement 15.6" "longdesc="Innolux BT156GW02 V.0 Laptop LCD Screen Replacement 15.6">
  <figcaption>Innolux BT156GW02 V.0 Laptop LCD Screen Replacement 15.6"</figcaption>
</figure>
<figure>
  <img src="https://laptopscreenz.com/wp-content/uploads/156-WUXGA-40PIN-FHD-3.jpg" title="Innolux BT156GW02 V.0 Laptop LCD Screen Replacement 15.6" alt="Innolux BT156GW02 V.0 Laptop LCD Screen Replacement 15.6" "longdesc="=(B2)">
  <figcaption>=(b2)</figcaption>
</figure>

I'm using excel and I even have the kutools extension. I have this html snippet that i need to copy down thousands of cells, lets say im using an empty column , lets go with G how would I get the value of the contents whenever it refers to cell B2 in this snippet and furthermore when copied down column G how can I change the B2 instances to B3 , B4 , B5 , etc..

Pardon my ignorance there just so many features I'm just trying to be efficient because its tons of data to be created.. Thank you very much in advance for anyone that can offer help!

Bandersnatch

EDIT:
Sorry for the misunderstanding. I think I understand your problem now. You still need to break up the text at the locations where you want to insert the content from Column B. I counted four places in your screenshot, and divided the text like this:

I put these in D14:D18, but you can put them wherever you need to.

Now all you have to do is concatenate everything together using &:

=D$14&B2&D$15&B2&D$16&B2&D$17&B2&D$18

and you'll get these results:

The ampersands concatenate the nine sections, and B2 changes to B3, B4, etc. as the formula is filled down. Note the $'s in the Column D references. That prevents them from changing as the formula is filled down.

I hope this helps, and good luck.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-9

Comments

0 comments

From Dev

Related Related

Article

How to change cell value down one column into another but change the row value?

How to change cell value down one column into another but change the row value?

How do I require a cell in one column to have a value if a cell in another column (same row) has a value?

How to change background of DataGrid row depending on value in one column

How to change background of DataGrid row depending on value in one column

Change value from one column into another

How to change value of one cell onchange of other cell value in DataGridview

Change value in a cell based on value in another cell

Upon change in row value, Do a sumif one row back in another column

Upon change in row value, Do a sumif one row back in another column

How do i lookup a row on one dataframe based on the column cell value and append that to a row on another dataframe?

i have two drop down menus,if change the value of drop down one it will affect to another drop down

Possible to use drop down selection in one cell to change another cell?

move Rows up and down or change row color if the row cell value are the same gridview devexpress winforms c#?

How to change the row color based value of Cell in list view

How to Change the row Background color based on cell value

How to add a row and change cell value in DataGridView from a different thread?

How to Change the row Background color based on cell value

Change column value by row string value in R

Keep row if cell value exist in another column

Hww to change cell value of grid row

Change Row background color based on cell value

Change one value based on another value in pandas

Change the value of once cell based the value of drop down list

How to get the first row corresponding cell value if i change the other rows cell value in kendo child grid

Change value of cell in same row with google script if column has certain value

Change value of cell in same row with google script if column has certain value

Change colour of a cell based on the value in the cell and text in another cell

Change the formatting of a cell depending on the value of that cell and another cell

Postgresql Trigger based on value of one column to change or update value of other column in each row.

pandas - change value in column based on another column