Premium Course: https://www.teachexcel.com/premium-co...
This tutorial shows you how to limit the entry of data into a cell to only those characters that are numeric or contained within the alphabet. You will be presented with a complex and easily customizable formula that will allow you to determine what a user can enter into a cell, combined with data validation. This tutorial will cover the steps needed to customize the formula and anything else that is required to implement this into a spreadsheet in Excel.
Watch video Excel - Allow only Text or only Numbers Entered into a Cell in Excel - Custom Formulas online without registration, duration hours minute second in high quality. This video was added by user TeachExcel 24 July 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 137,715 once and liked it 274 people.