CopyText

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I want to copy part of the text from one column to another. The text
has a \ in it and I need everything to the right of the \. If cell a
has adcd\efg and I was coping it to cell b then cell b would have efg.


Thanks
 
try this
Sub findslash()
For Each c In Selection
x = InStr(c, "\")
'MsgBox x
c.Offset(, 1) = Right(c, Len(c) - x)
Next
End Sub
 
Back
Top