ExcelBanter - Excel-Match 1st text character in a string to a known character?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel-Match 1st text character in a string to a known character? (https://www.excelbanter.com/excel-worksheet-functions/126182-excel-match-1st-text-character-string-known-character.html)

bushlite

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

vezerid

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

Ron Coderre

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

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