Find a,b,c then Replace with a.jpg,b.jpg,c.jpg...etc..

[muhammad susanto]

hi all....

how to use menu Find & Replace string like this below, adding .jpg

Excel 2007#E0E0F0 " />#E0E0F0 ;text-align: center;color: #161120">

	E
4	data
5	a
6	b
7	c
8	d
9	e
10
	after using Find & Replace
	data
13	a.jpg
14	b.jpg
15	c.jpg
16	d.jpg
17	e.jpg

<tbody>
</tbody>

#E0E0F0 ;color: #161120">Sheet1​

any help, much appreciated...

m.susant

 

[johnmpl]

Hi, muhammad susanto!

You can try this little vba code:

Sub Addtext()
  Selection = Evaluate("transpose(transpose(" & Selection.Address & " & "".jpg""))")
End Sub

First select the range to replace, and later execute this code. Blessings!