I have a problem with a source file in excel for my mail merge.

the field in excel has all lines of the address split by a / sign... there
are three in each cell e.g. anyhouse/anytown/anycounty/anyzipcode

how do i split the data out so i can produce my mailmerge

any ideas please