Another way is to select the range
edit|replace
what: /* (slash asterisk)
with: (leave blank)
replace all

Be aware that if you have
00012/1313abc
excel will be left with 00012 and that's just the plain old number 12. And
that's what you'll see unless/until you apply formatting to the cell

Like: format|cells|number tab|custom category|00000

wrote:

HI hope some one can help
i have been tring to wolr this out myself by reading previous post but
i still none the wiser

i have a column of numbers and what i need to do is is ther is a / in
the field i need to delete it and any numbers after it
can someone please help i have looked at other examples but dont fully
understand what they do

Andy

--

Dave Peterson