INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Find and Replace

Find and Replace

(OP)
I am trying to do a find (say F205) and replace with(say T154), etc - long list.

Unfortunately some F205 were written as F$205 - do I have to do 2 separate find and replaces, or is there a (wildcard?) option that is faster? It would maybe save an hour or so of this tedium.

RE: Find and Replace

On a windows machine, in excel. hit Ctrl+f. then click the replace tab... enter the F$205 and replace it with T154. and just do this twice and use replace all. Use Replace All!

RE: Find and Replace

(OP)
Thanks Eric but what I meant was that I have along list of find and replaces, ie

F205 replaced w/ T154
F$205 replaced w/ T154

G205 replaced w/ T154
G$205 replaced w/ T154

etc

I could cut this effort in half if, say, F*205 could be interpreted as either F205 or F$205 etc, but apparently Excel doesn't do that

RE: Find and Replace

(OP)
oops I meant

G205 replaced w/ T155
G$205 replaced w/ T155

RE: Find and Replace

(OP)
wait..
This could be done (in this case) by copying the first corrected cell - but I need to transpose a couple sets of columns/rows first.

RE: Find and Replace

(OP)
I think I was going a bit loopy from all the major surgery I am trying to do on one of my worksheets.
I was hitting the Find Next button, and for some reason it went to a cell containing BF205, then AZ205, etc - all cells that shouldn't have been affected.

That's why I said the wildcard * wasn't working.

I ended up fixing all easily by just copying down the first corrected cell.

RE: Find and Replace

(OP)
OK now I get it (I think)
It doesn't work because B*205 could be interpreted as B205, B$205, BA205, BB205 etc, and there are many cells populated from the A column to the BQ column

RE: Find and Replace

Do you need to have the $ in any cells? If not, first find and replace all $ with nothing.

RE: Find and Replace

(OP)
jghrist,
Never thought of that, I will give it a try if needed in the future.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close