Excel Pro Trick: Separate Text And Numbers In Excel From Mixed Data using Go To Special - No Formula

Learn how to separate numbers and text from a mixed data in Excel without formula using Go To Special tool. With Go To Special tool we can easily split text and numbers in data range to separate columns in few seconds. In this Excel tutorial we learn how to use Go To Special tool to extract text and numbers to separate columns using Excel shortcuts in seconds. This method is unique in a way that we don’t have to use any Excel formula to get this task done. Lets Excel! Access or Download Practice Workbook for this Excel Tutorial: For more Excel tips, tricks and tutorials don’t forget to subscribe to @LearnExceltoexcel channel. Learn #Excel your way: =================== Website: -------------------------------------- Pick your favourite social page: Fb: Tiktok: Tw: Pin: Yt: Insta: h