[ExcelVBA] Find some text in the cell

 

Hi Experts,

I just want to idendify some codes in the specific cells, but i dont know the starting point and ending point where the code will start in the cell.

I have given below the example, Could you anyone help me on the issue.

Ex.

In a particular cell, I may have

Auto-Trip abjop NLC011234537
Auto-Trip af NLC0478654
Auto-Trip 12345 USC987689
Auto-Trip 2332 GBC998897676

In the above examples, I just want to get a boolian value either Ture / False if anywhere i find the codes NLC or USC or GBC. But I can't estimate where the starting point in the entire text.

I dont want VBA code, But it would be really helpful, if you could pcovide me cell comment which will extract the boolian value.

Regards
Manikandan Raghavan

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___