Hi George,
If all in a column you can use
Data, Test to columns, fixed length,
throw everything after the 7th position away.

test on a copy of the worksheet.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"George P" wrote in message ...
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!