Thread: From Column A get Text from Colum B
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default From Column A get Text from Colum B
a macro

mr=range("i22")
mr.value=LEFT(mr,FIND("-",mr)-2)

I believe it should be more like this...

Set mr = Range("B1")
mr.Offset(0, -1).Value = Left(mr.Value, InStr(mr.Value, "-") - 2)

Rick
Reply With QuoteReply With Quote