isolate

Hey, guys! I have a 10-column sheet with both unique and non-unique values (which are actually text, not numeric values, if this matters) across different columns. For example... column 1 has 27 rows of text, column 2 has 33 rows of text, column 3 has 14 rows of text, column 4 has 62 rows of...

Hi, all, I need just a certain data from a text, but I'm having a great problem trying to get only what I need when a pattern isn't followed. for example: "dsadkjlk / lkadjs dl [sadasd] kjdasj [dasldkj / sdadas / dsadas/ dasdasd] adsdasd / dasds / asdasd" In this text I need only what is...

Here is the scenario, We have an excel list of terms but we want to isolate those terms that are proper names of schools. In real life we want to isolate the proper name term from the following list cat dog Murry's school church Is there such a function?? Thanks!

I have this line of code in my project that is giving me a "Unable to get the Match property of the WorksheetFunction class" ... dln = WorksheetFunction.Match(td, swb.Worksheets(2).Range("B:B")) dln is defined as a variant (???) td = NOW The value I am getting for td is 5/7/2018 8:03:04 PM...

I have column "A", with a list of names, preceded by a two digit number. I need to isolate that two digit number in column "B". Thank you.

I have the following in A1 "Floating/Personal Holiday (FPH)". I want to isolate only "FPH". I have the following formula: RIGHT(A1,LEN(A1)-FIND(" (",A1)-1) but it's giving me "FPH)". How do I isolate only "FPH"? Thank you in advance.

Dear MrExcel community, I have a long list of data (10s of thousands of rows). Its behavioural data on a fish moving in and out of different 3 different zones (DECR, OFF, and INCR) in an aquarium. I need to separate/isolate the first row every time the fish move from one zone to another (bold...

I am trying to write a formula that will look at a date in column H2 and determine if that date is a prior week, week 1 or week 2 For example anything older than or equal to 8/19/17 is prior, any date between 8/20-8/26 is week 1, and any date between 8/27-9/2 is week 2. I have it already done...

Isolating non-numeric data in an IF statement <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am trying to run, what I would think is a fairly simply formula, though I am having trouble finding any information on-line. <o:p></o:p> If I have a range of...