Thread: Compare One Cell to the First 10 Characters of Another Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jill Jill is offline
external usenet poster
  
Posts: 52
Default Compare One Cell to the First 10 Characters of Another Cell
I would like to compare one cell (A1) to the first 10 characters in a range
of cells (B1:B125). If there is a match, I would like it displayed in C1.

Any help would be appreciated.

--
Jill
Reply With QuoteReply With Quote