Limit number of charaters in a cell

[Michael Coffee]

I am importing data from a DB, then running a macro to
change the appearance of the data. I need part of that
macro to cut the number of characters in a certain column.
The cells are imported with anywhere from 15 to 20
characters but I only want 10 characters. I tried going
through data validation settings, but that only effects new
entries, not imported data. There is probably a formula I
could enter, but I am not sure what it would be. Thank you
for any help you can provide.

 

[Ron de Bruin]

You can use a helper column with a formula like this

=LEFT(A1,10)
And use Copy>pastespecial to make it a value

Or do you want to use a macro to to do it?
Post back if you want that