CODEWITHSUNDEEP
excelexcel-formula
ChunkyFresh
ChunkyFresh

Reputation: 65

Excel - Place Changing Text of Cells

I know there are probably multiple ways of accomplishing what I'm about to inquire, but I don't have full understanding of excel's functional capacity so I'm working with what I know.

Here's how the set up looks in my excel workbook. 

  |---|---------------------|--------------------|---------------------|
  |   |          A          |         B          |         C           |    
  |---|---------------------|--------------------|---------------------|
  | 1 |image_north.001.jpg  |image_north.002.jpg |         x           |
  |---|---------------------|--------------------|---------------------|
  | 2 |image_south.002.jpg   image_south.002.jpg |         y           | 
  |---|---------------------|--------------------|---------------------|

And Cell C1 (x) contains all of this below....

  <!DOCTYPE html>
  <html lang="en">
  <head>
    <meta charset="utf-8">
  </head>
  <body>
  <TABLE>
  <TBODY>
  <TR>
    <TD><IMG style="HEIGHT: 200px; WIDTH: auto" 
    src="https://example.web.link/image/property/" width=486 height=647> 
    </TD>
    <TD><IMG style="HEIGHT: 200px; WIDTH: auto" 
     src="https://example.web.link/image/property/" width=486 height=647> 
    </TD>
    </TR>
</TBODY>
</TABLE>

What formula do I have to write to get this output on C1 itself or D1?

  <!DOCTYPE html>
  <html lang="en">
  <head>
    <meta charset="utf-8">
  </head>
  <body>
  <TABLE>
  <TBODY>
  <TR>
    <TD><IMG style="HEIGHT: 200px; WIDTH: auto" 
    src="https://example.web.link/image/property/**image_north.001.jpg**" 
    width=486 height=647> 
    </TD>
    <TD><IMG style="HEIGHT: 200px; WIDTH: auto" 
     src="https://example.web.link/image/property/**image_north.002.jpg**" 
     width=486 height=647> 
    </TD>
    </TR>
</TBODY>
</TABLE>

**Y would just be a matter of dragging the formula down.

I guess what I'm not able to figure out is how to INSERT string into string. I tried making the template into a formula by placing "=" before it, but I kept getting an error.

May I get some help with this please?

Thank you!

Upvotes: 0

Views: 39

Answers (1)

Ricardo Diaz
Ricardo Diaz

Reputation: 5696

Replace the C1 template with this text:

Notice the placeholders after "property/" -> "< image 1>" and "< image 2>"

  <!DOCTYPE html>
  <html lang="en">
  <head>
    <meta charset="utf-8">
  </head>
  <body>
  <TABLE>
  <TBODY>
  <TR>
    <TD><IMG style="HEIGHT: 200px; WIDTH: auto" 
    src="https://example.web.link/image/property/<image 1>" width=486 height=647> 
    </TD>
    <TD><IMG style="HEIGHT: 200px; WIDTH: auto" 
     src="https://example.web.link/image/property/<image 2>" width=486 height=647> 
    </TD>
    </TR>
</TBODY>
</TABLE>

In D1 enter this formula:

=SUBSTITUTE(SUBSTITUTE(C1;"<image 1>";A1);"<image 2>";B1)

This would be the set up

enter image description here

Upvotes: 1

Related Questions