Thread: If formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default If formula
Hi Biff,
Jumping in.
Very cool!
Regards - Dave.

"T. Valko" wrote:

Try this:

=LEFT(B2,FIND("-",B2&"-")-1)

--
Biff
Microsoft Excel MVP

Reply With QuoteReply With Quote