replaces

  1. T

    Use A dropdown then get vba to over type it

    Hi Everyone, So i have a sheet called"Home" Range R9 is a dropdown list from Range BE1:BE6 In BF1:BF6 I Have a list of Letters. What I want to do is Have the dropdown list in R9 then when you select it triggrer a macro that replaces it with the letter in column BF next to what you chose...
  2. L

    Excel stop converting text to number automatically when find and replace

    The data I copied from web has non-breaking space on all the columns. When I find and replace it in the workbook, it changes all the text values to numbers. I have a column with values "00001", "00002", it replaces all of them to 1, 2. Is there anyway I can fix this?
  3. B

    Remove all Non-Printable characters as well as Clean and Trim; leave name text intact with spaces

    I saw Rick Rothstein's code that removed Non-Printable Characters, and did a Clean and trim as well. Can it be modified to leave spaces in the middle alone? such as, if I have a column of names that may have leading or trailing spaces, or both...Like so: Alfred E. Newman John Paul Jones I'd...
  4. C

    SUMPRODUCT using IFERROR

    can someone walk me through a very basic example using sumproduct with iferror? In the attached I get a N/A error in J13. What I'm trying to to do is sumproduct but in when column H has an error is replaces the field with a 0. Thanks for the help.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top