Need help searching without defined characters

		Microsoft Office Forums > Microsoft Excel > Excel
Need help searching without defined characters

FAQ

Thread Tools

Display Modes

07-29-2013, 11:50 AM

Pecoflyer

Windows 7 64bit Need help searching without defined characters

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
FileSystemObject Compile Error: User-Defined Type Not Defined	gsrikanth	Excel Programming	2	03-28-2022 06:32 AM
Captions, self defined	stresscalcs	Word	9	01-29-2015 04:47 PM
Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err	tinfanide	Excel Programming	2	06-09-2012 10:19 AM
Application-defined or Object-defined error	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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:53 PM.