Aug 6 2003, 09:50 AM
Is there a way I can set a column up so that it automatically deletes the first two characters of any text pasted into each cell?
Thanks for any help.
Aug 6 2003, 11:11 AM
You could use the Mid() function. Take a look at the attachment. Is this what you are looking for?
Aug 6 2003, 01:54 PM
It does what I want but it means having to hide and unhide the column containing the origianl text which rather defeats the object. Is there a way I can set up a worksheet so that it happens automatically without having to put the formual in another column?
Aug 6 2003, 03:27 PM
Yes, which column?
It'll be a change event and vb's right() function.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here