This formula is use for Ms-Excel 2003, 2007, 2010, 2013 or above. Perfect for visually enhancing your Excel reports / works, this guide is a must-watch for anyone looking to elevate their data presentation/shorting skills. Here's what you'll learn: Its a very useful formula to remove extra spaces for text or number in Excel Sheet and its a amazing short trick to use find and replace function, Short Key: Ctrl+H, popular and easy Excel Formula's used in this video TRIM and SUBSTITUTE FUNCTION. This video is made for those people, students or learner who have learning excel step by step Formula Descriptions: =TRIM(cell reference) =SUBSTITUTE(cell reference," ","") SELF PRACTICE FILE DOWNLOAD STEP BT STEP. https://rb.gy/7r7ty3 https://1drv.ms/u/s!AiWpDtd1KpZggWRWD... ➡️ Join this channel to get access to perks: / @ms-excelbyhassamqureshi-vm1hj Thank you for your support!. Hassam Qureshi - MHQ #Excel