Excel - Round and MRound Functions in Excel by Chris Menard

Would you do a tutorial that highlights all cells that have spaces in front of or in back of the data in the cell. I know how to fix that with the TRIM function, but it would be nice to see these spaces ahead of time.

Great tutorial. Thank you!

Dear Chris, I have to tell you that, as a desperate frenchman, I feel like you are the miracle I have been waiting so long for. You have guided me through the darkest excel sheets and now, thanks to your divine knowledge, my nightmares have disappeared. Thank you for enlightening me and I hope that, someday, the whole world will bow to your magnificience.

Your most loyal apostle.
Lil Tubercule

How does he know I am watching this on Sunday?!? (:-O)

Hi Chris Can I create a simple formula to round up figures to .95cent and round down to .45 cent from the one column ?

Hello @ChrisMenard I don't see the tutorial on roundup and rounddown on Nov 1, 2018, did I miss it?

Thank you! I messed around with Excel trying to get .99 for hours yesterday!