LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Default match some character in b1 to c1 and display on d1

Hello

Any functions to match at least some character in b1 to c1 and display it on d1?

like

b1 is clarice Leonie lee

c1 is clarice_lee @abc.com (without space)

d1 is Yes

OR
b1 is clarice Leonie lee

c1 is Carry_lee @abc.com (without space)
d1 is no

Last edited by clay8 : August 24th 12 at 08:22 AM
 
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
Cross match data in Col A v/s Col B and display match in Col 3 aquaflow Excel Discussion (Misc queries) 3 July 10th 08 05:07 PM
Find one character or another and display c8tz Excel Worksheet Functions 3 January 18th 08 06:05 AM
Limited character display Steve_zsli Excel Discussion (Misc queries) 5 August 8th 07 03:35 PM
Excel-Match 1st text character in a string to a known character? bushlite Excel Worksheet Functions 2 January 15th 07 06:36 PM
How do I display more than one match in a Index/Match formula? Trish Excel Worksheet Functions 0 September 26th 05 10:21 PM


All times are GMT +1. The time now is 02:42 AM.

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

About Us

"It's about Microsoft Excel"