![]() |
#1
|
|||
|
|||
![]()
Ok. I have a spreadsheet with 50,000 user names in column one. I would like to search for any usernames that have a particular setup. I would like to find all of the usernames that are three letters, followed by four numbers...they could be any letters or numbers, just in that certain pattern. I don't know how to conduct this search.
I have scoured the internet, but am not able to find an answer ![]() ![]() ![]() Thanks ![]() ![]() ![]() |
#2
|
||||
|
||||
![]()
Hi perhaps :
Code:
=IF(and(len(a1)=7,istext(left(a1,3)),isnumber(right(a1,4)+0)),"true","false")
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
gsrikanth | Excel Programming | 2 | 03-28-2022 06:32 AM |
![]() |
stresscalcs | Word | 9 | 01-29-2015 04:47 PM |
![]() |
tinfanide | Excel Programming | 2 | 06-09-2012 10:19 AM |
![]() |
Manit | Excel Programming | 4 | 12-08-2011 07:35 PM |
Junk characters (box-like characters) in Word file | Sashikala | Word | 1 | 04-20-2010 02:03 PM |