=left(cell,7)

use a helper column, maybe copying the results back afterwards

Steve


On Wed, 24 Jan 2007 23:07:12 -0000, George P
wrote:

I have a range of cells, all consistent with the first 7 positions. I
want
to remove everything to the right of the 7th position. I've tried
various
special characters in 'edit/replace' to no avail.

thanks for your help!