This channel was set up to help in your journey of becoming a Microsoft Excel maestro. Having a very good skill in Microsoft Excel is a "must-have" for you to succeed in your field of endeavour, as it is one of the most powerful and essential tools for analyzing data. My name is Olaniyi Sofunwa, and I am a professional Analyst with over 10 years experience of working with data, so whether you are a novice or a seasoned professional, this channel will help to sharpen your Data manipulation skills in Excel. So, take my hand, and let's walk together in your quest to become a "pro". 💪💪
Thank you for watching the tutorial and for your comment. To replace the already existing number with the newly generated numbers, - Please highlight and copy the new numbers - Put your cursor on the first cell where you want to paste it - Then go to the Home tab, and from the Paste option - Select "Paste Values". For example, if the numbers are generated on Cell A1 to A10, then highlight and copy these new numbers on Cell A1 to A10, put your cursor on Cell A1, then Go to the Home tab, you will see a drop-down menu with the Paste Icon From the drop-down menu, select Paste Values. These steps will paste and replace the existing numbers in the column with the new numbers. Please let me know if this is helpful.