Full Version: Automatically removing characters?
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
sherbs
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.
Grove
You could use the Mid() function. Take a look at the attachment. Is this what you are looking for?
sherbs
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?
Thanks
NateO
Yes, which column?
t'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.