| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel-Match 1st text character in a string to a known character?
Ex: Column B is "H01474A". Column C is "R". If first character of Column B
matchs Columm C then "Yes". If no match display blank. Thanks..... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel-Match 1st text character in a string to a known character?
=IF(LEFT(B2,1)=C2,"Yes","")
HTH Kostis Vezerides bushlite wrote: Ex: Column B is "H01474A". Column C is "R". If first character of Column B matchs Columm C then "Yes". If no match display blank. Thanks..... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel-Match 1st text character in a string to a known character?
Try this:
If NOT case-sensitive... =IF((LEFT(B1,1)=C1),"yes","") Otherwise.....for case-sensitive =IF(EXACT(LEFT(B1,1),C1),"yes","") Note: The false value really isn't a true Blank Cell....it returns an empty string. Does that help? *********** Regards, Ron XL2002, WinXP "bushlite" wrote: Ex: Column B is "H01474A". Column C is "R". If first character of Column B matchs Columm C then "Yes". If no match display blank. Thanks..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text records in Excel | Excel Discussion (Misc queries) | |||
| How do I search a text string in many excel worksheets (files)? | Excel Worksheet Functions | |||
| Trying to match a text string to a data table, any suggestions? | Excel Worksheet Functions | |||
| Remove last character of text string | Excel Worksheet Functions | |||
| Excel - Find & Replace text in a string | Excel Worksheet Functions | |||
Linear Mode
