delete all characters after an character

  • Thread starter Jean-Francois Boucher
  • Start date
J

Jean-Francois Boucher

Hi I have a spread sheet where I have a colum with pack size ex: 10/20'. I
would like to remove all character after the slash (/). I cannot use any of
amount of character beacause it's not always the same format but the slash is
always there.
Remember I have over 10000 lines.

Thank any help will be appreciated.
 
D

Don Guillett

try this. Also removes the /

Sub findslash()
For Each c In Selection
x = InStr(c, "/") - 1
MsgBox Left(c, x)
Next
End Sub
 
Top