Excel Find and Replace case

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/21/wKiom1Sp5cbTCbDwAAPL7mRkfak274.jpg "style=" float: none; "title=" 1.jpg "alt=" Wkiom1sp5cbtcbdwaapl7mrkfak274.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/1D/wKioL1Sp5oOgwWptAAPahcDnhOs828.jpg "style=" float: none; "title=" 2.jpg "alt=" Wkiol1sp5oogwwptaapahcdnhos828.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/21/wKiom1Sp5ceBwk0YAAQ-QUu-VMk914.jpg "style=" float: none; "title=" 3.jpg "alt=" Wkiom1sp5cebwk0yaaq-quu-vmk914.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/1D/wKioL1Sp5oXg0MypAAPOh0hkoSw156.jpg "style=" float: none; "title=" 4.jpg "alt=" Wkiol1sp5oxg0mypaapoh0hkosw156.jpg "/>

In two steps, the first step is to find the content from the "cells format from cell" selection, select the cell 358. That is, select 358 all formats, including font color, cell background, border.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/21/wKiom1Sp5cmjbiPOAASll9DDjtU077.jpg "style=" float: none; "title=" 5.jpg "alt=" Wkiom1sp5cmjbipoaasll9ddjtu077.jpg "/>

The second step is to replace, as required only to change the number to Chinese, you can now use "Select format from cell" To select the 358 cell style.

Then select "Format" "Number" "special" "Chinese lowercase number" to complete. 650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/58/1D/wKioL1Sp5ofDnPGlAANQtKmubhk756.jpg "style=" Float:none; "title=" 5-1.jpg "alt=" wkiol1sp5ofdnpglaanqtkmubhk756.jpg "/>"

There are two text boxes hidden in this case, with no background. So, with find and replace, locate condition object, select it and press DELETE to delete it.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/21/wKiom1Sp5cvzOg2yAAMiGRxQe68974.jpg "style=" float: none; "title=" 6.jpg "alt=" Wkiom1sp5cvzog2yaamigrxqe68974.jpg "/>

From the 30-day actuarial Excel exercise

"30 Days of Refined Excel" in the 3rd phase of the hot admissions-training syllabus and application method

Http://t.excelhome.net/thread-43265-1-1.html

This article from "Kirin Tea Room" blog, reproduced please contact the author!

Excel Find and Replace case