Sorry not sure where to put this but my colleage has a query

he has Have multiple lines in one cell broken up by a return carriage that I want to split into separate cells

if anyone can help would be greatly appricated

thanks Twilliam

Sorry Access 2000

Try using the Split() function employing the vbNewLine as the delimiter.