aCtivecell.value = left(activecell.value,instr(1,activecell.value,"/")-1)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JAmes" wrote in message
...
Hi Gang
How can I truncate text to the right of and including / in a cell. Woul
dlike to do it through code
Thanks!