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...
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?
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...
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 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.