The data has an extra line with a space as follows:
blank space
data
blank space
I need to move the text to columns but the data is blank, I'm assuming because the first line is blank.
Thanks.
I am trying to write a macro, which, when a date value is entered into one cell, 10 days after that date it will change the color of the cell to the right of it a shade of red.
This is what I have so far, but it's not working. Can anyone point out what I am doing wrong? Thank you!!!
Sub...
This should be super-simple.
I get lots of horribly formatted Excel sheets from my company where they will make all the columns 15 pixels wide.
Sometimes when I fill in a cell with a number or text longer than the cell, it will show up properly in the cell and "overhang" into the cell to the...
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.