remove unwanted text after the 7th position
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!
|