Re: $$Excel-Macros$$ Compare character types in 2 character string

You can also use.. =ISERR(--LEFT(A3,1))=ISERR(--RIGHT(A3,1)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Dec 16, 2011 at 11:27 PM, StephenM w

Re: $$Excel-Macros$$ Compare character types in 2 character string

=TYPE(VALUE(LEFT(H2,1)))=TYPE(VALUE(RIGHT(H2,1))) Here you go. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advic

RE: $$Excel-Macros$$ Compare character types in 2 character string

:33 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Compare character types in 2 character string Hi StephenM, =isnumber(left(a1,1))=isnumber(right(a1,1)) That will return TRUE if the first and last character are the same type (numeric or non-numeric). It will return FALSE if

RE: $$Excel-Macros$$ Compare character types in 2 character string

Hi StephenM, =isnumber(left(a1,1))=isnumber(right(a1,1)) That will return TRUE if the first and last character are the same type (numeric or non-numeric). It will return FALSE if they are different types. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@go