Use the TEXT functions LEFT and RIGHT to copy the leftmost and rightmost characters of a cell.
No download links available.
