Thread: Excel-Match 1st text character in a string to a known character?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
  
Posts: 751
Default 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.....

Reply With QuoteReply With Quote