Wildcards in Find & Replace

B

Bruce

Is it possible to use wildcards in the find and replace command?

For example, I have 10,000 rows where in each cell I have the text "
XXX-33000.ABC" where A, B, C are different numbers.

I want to replace this so that the l just end up with "XXX-33000"

Can I do something such as:

Find "33000.***"
and
Replace it with "33000"

Thanks in advance people!
 
J

Judy Freed

Yes, the way you have indicated you want to do this will work. YOu only
need to enter the asterisk one time - ie 33000.*, as Excel Help states that
an asterisk refers to any number of characters. The example they give
indicates that *east will find both Northeast and Southeast.

Judy Freed
 
L

Lee

I would use the following formula instead.... on your
example below using cell A1 that should return the value
XXX-33000

=LEFT(A1,9)

Lee
 
Top