I have string1 from which I extract string2 using function like left. Then I want to know if the string 2 contains number or letter. How would I accomplish this?
I have string1 from which I extract string2 using function like left. Then I want to know if the string 2 contains number or letter. How would I accomplish this?
Hi,
Does this work for you?
Assuming the extracted string is the first 3 characters of A1Please Login or Register to view this content.
Last edited by sweep; 10-16-2015 at 09:16 AM.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks