Keep first 11 characters (including spaces) in a column.

I only need the first 11 characters in column B from B1 to B12650, the rest of the characters need to be cleared from each cell. Will someone please help me and write a little VB macro for me to copy and paste?

Thanks,

Jan

Hi Jan,

You don't need to use a macro for this. In a blank column use =left(B1,11). When you get your results, highlight your column, right click and do paste special and values. This will convert your formula into your text or numbers.

That is awesome! Thanks, everyone! It worked! MUCH easier than I was making it out to be!! Have a great day!

Thanks again for the help!!