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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use of Wildcard characters with replace 2
Replacing using a wildcard 2
Find & Replace 2
Wildcard in the Replace function 2
Replace with wildcards 2
Find and Replace Command Using Wildcard Help 1
"Find" a wildcard as a place marker and "replace" with original va 1
Why not accept wildcards for REPLACE as well as FIND ? 5

Back
Top