Wildcards in Find & Replace

  • Thread starter Thread starter Bruce
  • Start date Start date
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!
 
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
 
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
 
Back
Top