Results 1 to 6 of 6

Formula for validating text in cell with pattern of numbers and letters

Threaded View

sweetusmile Formula for validating text... 07-17-2012, 10:44 AM
Special-K Re: Formula for validating... 07-17-2012, 12:52 PM
sweetusmile Re: Formula for validating... 07-18-2012, 04:44 AM
Ace_XL Re: Formula for validating... 07-18-2012, 07:33 AM
Haseeb Avarakkan Re: Formula for validating... 07-18-2012, 10:06 PM
sweetusmile Re: Formula for validating... 07-19-2012, 07:44 AM
  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Formula for validating text in cell with pattern of numbers and letters

    Hi,

    I am looking out for a excel formula that helps me to find out the cells that has first four characters as numbers and next two characters as letters. Eg - 1234AB. I have a list in column A that has only letters and only numbers and alphanumeric cells and a few cells in the above format of 1234AB etc. I want a formula that identify such cells out of the list. Can anyone help please?
    Last edited by sweetusmile; 07-17-2012 at 11:39 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1