Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Smile search cell for specific text.

Hello everyone!

I hope that one of you can help me with the following challenge (Excel 2010):

I need to search a cell (text) for three specific strings of text (so one of the values needs to be in place)(might be in between other text) and if that cell holds one of those three specific text strings then print that string in another cell.

I have searched the internet and i cannot seem to find the sollution for this.
I really hope that one of you can help me with this because i'm stuck on this.


Very very kind regards,

Tom.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,514
Default search cell for specific text.

vonsharkel formulated on Monday :
Hello everyone!

I hope that one of you can help me with the following challenge (Excel
2010):

I need to search a cell (text) for three specific strings of text (so
one of the values needs to be in place)(might be in between other text)
and if that cell holds one of those three specific text strings then
print that string in another cell.

I have searched the internet and i cannot seem to find the sollution for
this.
I really hope that one of you can help me with this because i'm stuck on
this.


Very very kind regards,

Tom.


Have a look at the FIND() function in the online help.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search for specific text within last non blank cell in a range Bevo Excel Worksheet Functions 2 September 5th 09 08:15 AM
Nested formula to search a text string and return specific text Barbie Excel Worksheet Functions 10 February 21st 09 07:40 AM
Search for cells that DO NOT contain specific text HowOnEarthDoI Excel Programming 4 October 21st 08 08:21 PM
Looking for a way to search for specific text across columns dathomas Excel Worksheet Functions 2 October 5th 06 08:30 PM
How do I search for specific text and sum the cell to the right? PacRat2001 Excel Worksheet Functions 3 October 12th 05 04:21 AM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"