Separate Text and Numbers in a Cell - Excel Formula

Separate text and numbers in a cell using an Excel formula. This video tutorial uses an Excel formula to separate the text and numbers in a cell that are not delimited by any character such as 15Hello. Without a delimiter character between the numbers and text this is difficult. The formula used on the video is very complex and therefore is explained thoroughly, and provided below. The formula below is used in the video. Copy and paste this formula and adapt it to meet your needs. =RIGHT(A2,LEN(A2)-MIN(FIND({"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},LOWER(A2)&"abcdefghijklmnopqrstuvwxyz"))+1) Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm