replace 1000 with nothing

Hello. If I have a bunch of text columns with a misplaced *1000, how can I replace that with nothing? I tried find and replace but it won't let me replace it nothing.

Hi,

Ideally "Find & Replace" should work here. Can you please post a sample template of your excel file?

I'll just give you an example. The value in A5 = "Jim", and the same is true for all the values in column A. However, in column B, I have formulas that say A5*1000. The*1000 results in a #value, so I need to get rid of those. This is an oversimplification of what I'm facing but essentially I need to understand how to eliminate "*1000" from a set of formulas.

Can you not use IFERROR in the formula?

=IFERROR(A5*1000,"")

No, haha. I want to return the value in A5. All this will do is give me "". I want to get rid of the *1000.

How about this?

=IFERROR(A5*1000,A5)

You can use Find & Replace for this, but as the string that you want to replace begins with *, which is a wildcard character, you need to use the tilde symbol ( ~ ) in front of it, which tells Excel to treat the next character as text, i.e.:

select the cells affected
CTRL-H
Find what: ~*1000
Replace with: leave blank
Click Replace All

Hope this helps.

Pete

THat's what I'm talking about. Thanks!!