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

[janlee43]

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

[Special-K]

Just use a Helper column

in C1
=LEFT(B1,11)
and copy down column C

[volleyballtigger]

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.

[janlee43]

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

[janlee43]

Thanks again for the help!!