Gavint
08-29-2006, 08:03 PM
I need a simple macro to check a cell and removes any text after the first 4 characters, then loops through each cell in that column until finished (no more text).
The cells are going to have some text (between 6 and 15 characters long), but only the first 4 characters are relevant, so the rest needs to be deleted)
I had a play with string lengths and looping, but I'm not having much luck getting it to work.
Thanks!
The cells are going to have some text (between 6 and 15 characters long), but only the first 4 characters are relevant, so the rest needs to be deleted)
I had a play with string lengths and looping, but I'm not having much luck getting it to work.
Thanks!