Limit number of charaters in a cell

  • Thread starter Thread starter Michael Coffee
  • Start date Start date
M

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.
 
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
 
Back
Top