# I would like to ask how to find the number of Excel

Excel document that is, I would like to retain some of the text, all the figures want to go, what formula to replace it?

Do the following method, a copy of the proposed stand-by.

Method 1

the premise:1, only the cell number or text (of a cell is either the number or text)

2, in digital format (Font size, etc.), format text and numbers

different:Edit – to replace – point out options, where to find content options, click on the right side of the drop-down format, from the cell format to choose, at this time Arbitrary selection of a number of the cell, and then look for all, all of the replacement.

Method 2

editor – to replace, to find the contents of 1, Replace All, and then find the contents of 2, all of the replacement, and then find the contents of 3, all of …..Look up to replace the contents to find the content 0 ..9, the replacement of all.Assumption that contain digital data in the A1, in point B1

menu:Insert – the name – the definition of pop At the …

Dialog box, set up an arbitrary name, such as the following quote aaa

location, type

= SUBSTITUTE (SUBSTITUTE (SUBSTITUTE (SUBSTITUTE (SUBSTITUTE (SUBSTITUTE (SUBSTITUTE (A1, “0 “,””),” 1 “,””),” 2 “,””),” 3 “,””),” 4 “,””),” 5 “,””),” 6 “,””)

determine

At this time, B1 in the formula for the importation of

= SUBSTITUTE (SUBSTITUTE (SUBSTITUTE (aaa, “7 “,””),” 8 “,””),” 9 “,””)

B1 formula can be copied down in order to remove A column of figures

## Leave a Reply

You must be logged in to post a comment.