Re: [ExcelVBA] Find some text in the cell

 

You could use, assuming the text is in cell A3,

=IF(AND(ISERROR(FIND("NLC",A3)),ISERROR(FIND("USC",A3)),ISERROR(FIND("GBC",A3))),FALSE,TRUE)

Regards

David Grugeon

On 29 September 2013 16:32, Raghavan Manikandan <geethanjali_mani@yahoo.com> wrote:

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


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

----------------------------------
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

----------------------------------Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ExcelVBA/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/ExcelVBA/join
    (Yahoo! ID required)

<*> To change settings via email:
    ExcelVBA-digest@yahoogroups.com
    ExcelVBA-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    ExcelVBA-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://info.yahoo.com/legal/us/yahoo/utos/terms/

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

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

.

__,_._,___