Thread: Strip 2 Numbers from a Hyphenated Range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Johnny[_11_] Johnny[_11_] is offline
external usenet poster
  
Posts: 6
Default Strip 2 Numbers from a Hyphenated Range
On May 20, 2:14*pm, "Chip Pearson" wrote:

Try:
=TRIM(LEFT(A1,FIND("-",A1)-1))
and
=TRIM(MID(A1,FIND("-",A1)+1,99))


Chip, right on the money.

Thanks
John
Reply With QuoteReply With Quote