Power Query: I have a column with strings and a list of words I need found in that column AND (this is the difficult part) when found these words need to get cut off from the string (or replaced by "")? How? A sort of textual substraction... have been trying so long... list.accumulate etc...
Hello everyone,
I'm working with a line chart that (dates on the X axis and some series of data in the Y axis), when i add new columns of data (new dates with data), the x axis extends, but the chart area does not "adapt" to it, so the new part of the chart with the new data doesn't "fit" the...
Hi everyone,
I'm having trouble printing my excel sheets because the charts have lots of boxes with information, and when I print, some of the numbers above the bars are cut off (like a white dash as you can see below), which probably means some of those boxes are over the numbers...
Hi,
My name is Puneet and I need your help to solve the following problem with Excel VBA code.
I need to automate the process of entering process date in excel sheet. Process date is calculated on the basis of following rules:
1. It is equal to effective date (say date entered in V column.
2...
My father-in-law phoned me with an issue he is having with all of his Excel documents, old and new. Each document seems to cut off at column B when he prints or checks print preview. I walked him through how page setup works. I had him check the print area, and sure enough it was set to cut off...
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.